Page 1 of 1
Propagating Column Length in Next Stages
Posted: Tue Mar 20, 2018 10:15 am
by syedmuhammedmehdi
Hi, I need to change a column length and type in all stages till Target from Source stage. There are many stages in between. Could anyone please advise is there any shortcut to propagate column attributes in next stages till target stage?
Posted: Tue Mar 20, 2018 10:39 am
by ArndW
Unfortunately not.
Posted: Wed Mar 21, 2018 12:45 pm
by chulett
Sounds like a question from a former Informatica person... because there you can.
Posted: Wed Mar 21, 2018 3:48 pm
by ray.wurlod
You could achieve this had you created your job design using runtime column propagation.
The DataStage flow designer (new in version 11.7) allows metadata propagation too.
However, there is nothing in DataStage that allows a manual change to be propagated through stages in which explicit column definitions occur.
That said, it would be possible to create a DataStage routine to achieve this. However, that routine would need to be re-written once IBM stops using the "UniVerse" database underneath the project.