More column in RCP and less column in Target?

dsdoubt · Post by **dsdoubt** » Sat Mar 03, 2007 5:14 am

Hi,
We are trying to use RCP.
Kindly let me know, What happens when more column transfered from source through RCP, but less column avaialble in target table?

ray.wurlod · Post by **ray.wurlod** » Sat Mar 03, 2007 5:56 am

It depends on many factors. Rather than try to canvas them all here, why not try what you have in mind, and report the results back to this thread?

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Sat Mar 03, 2007 3:34 pm

Many Factors !!??

ray.wurlod · Post by **ray.wurlod** » Sat Mar 03, 2007 6:35 pm

Yes, for example RCP must be enabled in Adminstrator then, even if it is, can be enabled/disabled on a per-stage basis in the processing stream. Is the stage type amenable to using a schema file and, if so, is it? Will that get you going?

dsdoubt · Post by **dsdoubt** » Sat Mar 03, 2007 7:58 pm

My concern is not to enable or disable it. If RCP is enabled, and If I use schema file, which has more columns (by chance) and if the target table as less number of columns in that job... Will it error out or will the columns found in last will be sielently discarded or will the system collapse.
We are in design phase, and dont have frequent access to Datastage to test it.
So kindly let me know guys.

ray.wurlod · Post by **ray.wurlod** » Sun Mar 04, 2007 10:32 am

GET access. That's the only way to test things.

kumar_s · Post by **kumar_s** » Sun Mar 04, 2007 11:47 pm

Database like DB2 / Oracle has the option to specify "Silently Drop the unavailable column". Enabling this, should help to avoid the errors poping up when source fields are not available in Target tables.

chulett · Post by **chulett** » Mon Mar 05, 2007 1:53 am

Or a system collapse.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Mon Mar 05, 2007 4:52 am

Oh!!

From the question raised, I just took that the RCP is enabled until the stage level.

So I will go with kumar_s's answer.