What are the main features of 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 types of database.
* Handles all the metadata definitions required to define your data warehouse.
* You can view 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.