DSXchange

Hi,

I need to set the soft delete flag in the dB. Data is coming as below

The data is coming as

Key Image
123 1234
123 1234

124 145
124 0

154 0
154 0

In above scenario 1 has no change , 2nd is delete as it has before image and after image is set to '0'

The third has no after and before image i.e. by default come as '0'

o/p should be

Key Image Flag
123 1234 N
123 1234 N

124 145 Y
124 0 N

154 0 N
154 0 N

I tried with stage variables but it falls out.

Thanks in help for advance.

Regards,
-M

Why aren't you using one of the change detection stages (Change Capture, Difference or Compare stage)?

Hi Ray,

I thought of it but change capture stage o/p only one row and I will loose my before image these are the messages from MQ series with before and after images coming in unit of work.

Regards

ray.wurlod wrote:Why aren't you using one of the change detection stages (Change Capture, Difference or Compare stage)?

So use Compare stage, which outputs both inputs.

Hi Ray,

I tried using it but compare stage only o/p one link.

Regards,

ray.wurlod wrote:So use Compare stage, which outputs both inputs.

There's only one output but it contains three fields: the first input row (as a subrecord), the second input (as a subrecord) and the difference result.