Soft Delete

[shrey3a]

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

[ray.wurlod]

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

[shrey3a]

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

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

[ray.wurlod]

So use Compare stage, which outputs both inputs.

[shrey3a]

Hi Ray,

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

Regards,

So use Compare stage, which outputs both inputs.

[ray.wurlod]

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.