Delete records generation from before dataset 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
scope123
Participant
Posts: 9
Joined: Tue Jun 15, 2010 10:32 am

Delete records generation from before dataset issue?

Post by scope123 »

The problem was i was not able to get delete records out of the change capture.im getting a null value for all th columns in the record which was designated as a delete record.

can any one suggest me that why the values are empty?
scope123
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Because this stage type gives you the "after" record on the output.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
scope123
Participant
Posts: 9
Joined: Tue Jun 15, 2010 10:32 am

Post by scope123 »

Difference stage gives before dataset but not after dataset.
using which stage i can incorporate this logic? please suggest me.
scope123
SURA
Premium Member
Premium Member
Posts: 1229
Joined: Sat Jul 14, 2007 5:16 am
Location: Sydney

Re: Delete records generation from before dataset issue?

Post by SURA »

Always try to understand what Ray trys to point out. You will always get a hint.

Consider your linking order.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Please clarify which stage type you are using. In your first post you said Change Capture stage, later you said Difference.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply