If a DDL is made to the database, it should not effect job i.e. we shouldn't be changing datastage jobray.wurlod wrote:Welcome aboard.Why?mfshah wrote:The jobs should be dynamic/flexible and pick the metadata information at run time
Search found 2 matches
- Tue Feb 16, 2010 8:57 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Picking metadata at run time
- Replies: 5
- Views: 1996
- Mon Feb 15, 2010 11:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Picking metadata at run time
- Replies: 5
- Views: 1996
Picking metadata at run time
I have to load data from oracle(source) to teradata(target). The jobs should be dynamic/flexible and pick the metadata information at run time i.e. If a change has made to the data model it shouldn't effect the DataStage job design. Say Col A was previously varchar 5 and now the lenght has increased...