Hi
while loading the 7th rec, In the transformer I want to store the column value of 6th rec and add that column value to 7th rec based on certain condition and populate it to tgt,
Only thing is I am not getting idea as how to get the value of 6th rec which already populated into the tgt table just before this 7th record
Any help would be really great
Thanks
Suresh
to store column value of previous rec
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 57
- Joined: Sat Jun 09, 2007 1:14 am
- Location: chicago
to store column value of previous rec
Hi I have experience in parallel extender datastage I am ready to give/take help from other
hope we all help each other hand in hand
hope we all help each other hand in hand
This is a classic example of the use of stage variables and works in both Server and PX jobs. If you have a stage var "LastValue = In.ColumnName" then any stage var defined before that assignment will have the value from the last value. In PX jobs you need to take the partitioning into account, though.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>