Store source table name in the target

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
sainath
Premium Member
Premium Member
Posts: 138
Joined: Fri Nov 19, 2004 3:57 pm

Store source table name in the target

Post by sainath »

HI

I have to store the source code table name in the target and table definition are different for each source tables. how can I implement the above logic in data stage.

If table definition were same I can loop and pass table name as parameter and store in target.

Please share your idea.

thks
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Can you please make your requirement clearer? In particular, what do you mean by "source code table name"?

Certainly if this is a job parameter, it becomes simplicity itself to store that value in a target.

It's decidedly unclear what you want to do with the table definition.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Was wondering much the same things. Also out of curiosity, what exactly is your target?
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply