More column in RCP and less column in Target?
Moderators: chulett, rschirm, roy
More column in RCP and less column in Target?
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?
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?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
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.
We are in design phase, and dont have frequent access to Datastage to test it.
So kindly let me know guys.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom