runtime column propagation on Oracle enterprise output

sudhirk63 · Post by **sudhirk63** » Tue Jan 27, 2009 11:17 am

Hi.

I am trying to use rcp to pass on columns I do not transform directly from input oracle enterprise stage to output oracle enterprise stage.

On the onput stage I use the upsert stage. After running the job, I can only pass on the columns which are defined in the output stage metadata.
It seems the columns whose value can be passed to target is hard bound by SQL in the output stage.

I was able to use rcp with ODBC stage though.

Is there a trick to use rcp to output columns not defined in the job metadata using Oracle enterprise stage.

throbinson · Post by **throbinson** » Tue Jan 27, 2009 11:57 am

I have done it with the Teradata API stage but it is definitely a case of the operation was a success but the patient died. I pre-built the SQL as a parameter based on a job that reads the system tables. This parm was passed to the Upsert job in the custom SQL.

sudhirk63 · Post by **sudhirk63** » Mon Feb 02, 2009 1:58 pm

Thanks throbinson for your suggestion.

I used ODBC stage as I do have lot of data to tranform at a given time.