Oracle connector stage drop unmatched fields insert issue

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
satheesh_color
Participant
Posts: 182
Joined: Thu Jun 16, 2005 2:05 am

Oracle connector stage drop unmatched fields insert issue

Post by satheesh_color »

Hi,

When i try to insert records into Table A, by using oracle connector stage(Oracle 10g) with Drop unmatched fields option(Set an Yes) i could see a weird response.

Using performance statistics / job monitor i could see the records were populated into the target DB table. When i see the table there were no such records.

Your thoughts / help will be much appreciated.


Regards,
Satheesh.R
rkashyap
Premium Member
Premium Member
Posts: 532
Joined: Fri Dec 02, 2011 12:02 pm
Location: Richmond VA

Post by rkashyap »

Review the Director log. You can also look at debugging information for the Oracle Connector, generated on executing the job after setting CC_MSG_LEVEL to 2.

Most probably records are getting rejected. Is there reject link for Oracle Connector stage?
Post Reply