Hi SDN,
Please help me with the following:
During a transformation, if the load is a delta load, the data set contains both from the 0RECORDMODE perspective, such as type: "N", "X", "R" and blank.
What happens to each type of record during:
1. Start Routine (what should we do or not do with 'X' and 'R' type rows)
2. Transformation Rules (Do these rules apply to 'X' and 'R' rows?
3. End Routine ( I don't see 0RECORDMODE) in the Result Package. What happens to the 'X' and 'R' type rows which need to continue onward to delete/change records further on?
Please advise.
SM
PS. Points are always awarded.
Further on this:
For this data packet:
RECORDMODE Order Item P'Key
1 N 0004337570 000005 001
2 X 0004337570 000005 001
3 0004337570 000005 001
4 R 0004337570 000005 001
I was expecting the End Routine to have an empty Result Package but I see the Result Package having one row. Suggestions?
Thanks.
SM
Add a comment