Hi,
Can someone tell me logic for this scenario:
From the left link, records are coming in this way:
col1 col2 col3 col4 col5 col6 PK
a null b c null d V1
null b d e f null V2
v null f null d h V3
b J C null s a V4
Now, what I have to do is, for each record, take all fields which are not null and update them for the same fields of some other record in the same table. How can I do this.
i.e. for all fields of suppose V2, which are not null, update the values wherever V2 is not null in V1.
This is urgent.can someone pls guide, since, If I compare with field names to be not null, the same field name can be null for one row and have value for another record..how do i build this logic in datastage, which stages can i use etc?
regards,
Sumati.
Logic needed for this scenario
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I am certain that this exact question has been answered recently. How about you Search for it?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.