Page 1 of 1
More column in RCP and less column in Target?
Posted: Sat Mar 03, 2007 5:14 am
by dsdoubt
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?
Posted: Sat Mar 03, 2007 5:56 am
by ray.wurlod
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?
Posted: Sat Mar 03, 2007 3:34 pm
by Sainath.Srinivasan
Many Factors !!??
Posted: Sat Mar 03, 2007 6:35 pm
by ray.wurlod
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?
Posted: Sat Mar 03, 2007 7:58 pm
by dsdoubt
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.
Posted: Sun Mar 04, 2007 10:32 am
by ray.wurlod
GET access. That's the only way to test things.
Posted: Sun Mar 04, 2007 11:47 pm
by kumar_s
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.
Posted: Mon Mar 05, 2007 1:53 am
by chulett
Or a system collapse.
Posted: Mon Mar 05, 2007 4:52 am
by Sainath.Srinivasan
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.