Search found 2 matches

by mfshah
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: 1994

ray.wurlod wrote:Welcome aboard.
mfshah wrote:The jobs should be dynamic/flexible and pick the metadata information at run time
Why?
If a DDL is made to the database, it should not effect job i.e. we shouldn't be changing datastage job
by mfshah
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: 1994

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...