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?

[OSCommManager]

Question (cont)

The client is loading rows with net zero values from the source system and currently these are being loaded to a suspense account. 

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