Page 1 of 1

Store source table name in the target

Posted: Wed Apr 12, 2017 3:14 pm
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

Posted: Wed Apr 12, 2017 10:07 pm
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.

Posted: Thu Apr 13, 2017 7:19 am
by chulett
Was wondering much the same things. Also out of curiosity, what exactly is your target?