Using of RCP(Runtime Column Propagation)

jack_dcy · Post by **jack_dcy** » Mon Jul 25, 2005 9:17 pm

Hi all,
I don't check the option of "Enable Runtime Column Propagation in Parallel Jobs" in the Datastage Administrator, because I think there have some bugs in some stages, such as lookup.

Pls give me some suggestion about this.

ray.wurlod · Post by **ray.wurlod** » Mon Jul 25, 2005 9:26 pm

Please post your reasons for believing that there are bugs. Be specific about stage types and nature of bug in each case.

I usually advocate not using RCP but not because of any bug. My reason is that tools such as MetaStage can't provide usage/lineage analysis of columns that are generated "on the fly". Nor should it be able to!

jack_dcy · Post by **jack_dcy** » Tue Jul 26, 2005 12:09 am

Hi ray

sorry, I forget the bugs, maybe it is not a bug. I will find it.

By the way,Will the RCP improve the performance very much?

ray.wurlod · Post by **ray.wurlod** » Tue Jul 26, 2005 1:31 am

No.

Runtime propagation adds columns that are in the schema but not explicitly in your design. If anything, one could argue that this degrades performance (the extra processing to make that decision). In practice, though, it's negligible.