DATASTAGE:

DataStage has the following features to aid the design and processing required to build a data warehouse:

    • Uses graphical design tools. With simple point-and-click techniques you can draw a scheme to represent your processing requirements.
  • Extracts data from any number or type of database.
  • Handles all the metadata definitions required to define your data warehouse. You canview and modify the table definitions at any point during the design of your application.
  • Aggregates data. You can modify SQL SELECT statements used to extract data.
  • Transforms data. DataStage has a set of predefined transforms and functions you can use to convert your data. You can easily extend the functionality by defining your own transforms to use.
  • Loads the data warehouse.

Leave a Reply