Propagating Column Length in Next Stages

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
syedmuhammedmehdi
Participant
Posts: 43
Joined: Wed Feb 12, 2014 12:34 pm
Location: Hyderabad, India

Propagating Column Length in Next Stages

Post 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?
SyedMuhammadMehdi
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Unfortunately not.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Sounds like a question from a former Informatica person... because there you can.
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post 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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply