DataStage

What is Transformation Server?

Transformation Server (TS) is a software solution that:

–

Connects two or more databases together

–

Works on a variety of systems (Windows NT, iSeries, etc.)

–

Works with a variety of databases (Oracle, DB2, etc.)

–

Captures, transforms and flows the data in real-time •

Capture: Grab/copy changes to data as the change occurs

•

Transform: Modify the data using filters, calculations or functions

•

Flow: Send the data to another database

•

Real-time: Without any delay, changes are immediately sent

Components of Transformation Server