How did you solve it? I have the same scenario. The source file is schema file driven, and I need these few extra columns added. I need to populate one of the columns with Oracle sequence call and the others hard coded.juancho wrote:Thanks!
Solved it.
I took the Unix route and its fairly easy to achieve this, but Performance is terrible.
The other way I can think of is, get the source schema file at unix level and add it the columns I want and make up the target schema file. This way I can have a Transformer stage in the middle of source and target schema files and I can define those static columns and their derivations in the Transformer.
I would like to know if there is a better way to achieve this.
Thank You.