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
Soft Delete
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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
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)?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: