Transformations and 0RECORDMODE
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?
PS. Points are always awarded.