Microstrategy Online Training

DataStage DataStage is just another application on the server, an application which connects to data sources and targets and processes ("transforms") the data as they move through the application. Therefore DataStage is classed as an ETL tool. DataStage "jobs", as they are known, can execute on a single server or on multiple machines in a cluster or grid environment. DataStage also has a set of Windows-based graphical tools that allow ETL processes to be designed, the metadata associated with them managed, and the ETL processes monitored. These client tools connect to the DataStage server because all of the design information and metadata are stored on the server.