Change Data capture

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
rajeevm
Participant
Posts: 135
Joined: Sun Jan 22, 2006 10:44 am

Change Data capture

Post by rajeevm »

Hi

I have a encountered a problem when using change data capture stage ,the problem is I am comparing old file and new file, the old file 206 records and new file has 205 records , there was one record missing the new file and that file should be inserted into the database with status cd 'T' But when i ran the job all the rows are getting after the change capture is done. Its the similar job which i did before that job ran ok now this one i am facing problem.

I would appreciate your quick responses



Thanks
rajeev
shivajid2k
Participant
Posts: 19
Joined: Mon Feb 14, 2005 11:34 pm

Re: Change Data capture

Post by shivajid2k »

Verify the data in new file and check any extra spaces or characters are there.
Post Reply