Sunday, April 28, 2013

Datastage :Generic Data Processing

ETL is all about moving and transforming data. Transformation is almost always specific to the file or table that is being processed but moving is a generic action. Data is moved from on place to another and the only thing that differs is the structure of the data.
In almost all cases, the very first set of jobs created in an ETL application is used to moved data from the source to a landing area. In the past, a job had to be created for every table or file that had to be moved. DataStage has some nice features that allow us to build a single job that can be used to process data in a generic way.

0 comments:

Post a Comment

Please Post your Comments..!