Question: I am trying to clear out aggregated zero value rows after the transformation rules have been run but prior to the intersection validation. Can this be done without directly impacting/deleting rows in the stage tables?

Answer

• It is possible to interact with the process using an event handler business rule.  However, you are likely to have to impact the stage data and may lose the auditability via drill down.
• Another option may be to look at using derivative rules to aggregate these rows into a single line, bypass the original rows and check the derived value is equal to zero.
• We would suggest engaging the Integration team via a Support ticket if additional assistance is required.

 

Source:  Office Hours 2021-04-29 - Partner Enablement