Loading Tables on

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

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

Post by ray.wurlod »

No problem, provided that the table can accept duplicate rows (if there are going to be any) or your job generates unique keys on each link feeding the table.

FileA ---> TransformerA ---->T
A
FileB ---> TransformerB ---->B
L
FileC ---> TransformerC ---->E

In each Transformer stage, for example, the derivation expression for the key column might contain a different constant in each stage (say the letter) and the input row number from the input file. For example the link feeding the table from TransformerC might have its key column derived as "C":@INROWNUM, which would generate key values "C1", "C2", "C3", and so on (datatype probably VarChar in the table).
Post Reply