Posted: Wed Oct 02, 2002 12:54 am
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).
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).