DSXchange

Hi,

I had a query in parallel jobs RCP functionality

What is the use of Run time column propagation ? Is it mandatory to use it in parallel jobs ? what is the impact if RCP is disabled in a parallel job involving oracle connector stage ?

The short answer is that Runtime Column Propagation allows you not to specify complete metadata; you only have to specify the columns on which you want to perform transformation. Columns available on the input will be propagated through the stage even though they're not named, when RCP is enabled.

To add to that, it is in no way 'mandatory' but more of a technique that is used in conjunction with schema files. And it's all in the manuals.

What I like to say about RCP is:

If you know what it is doing, it is doing it FOR you, If you don't know what it is doing, it is doing it TO you