You must ensure that all records from the Customer table in the Alpha database are being moved to the Delta staging database using the audit logs.
In the Local Object Library, replicate the Alpha_NACustomer_DF data flow. Name the replicated data flow Alpha_AuditCustomer_DF . Add the replicated data flow to a new job, Alpha_AuditCustomer_Job. Set up auditing on the data flow Alpha_AuditCustomer_DF by adding an audit rule to compare the total number of records in the source and target tables.
How to Add an Audit label for the new target table and create a custom audit rule to verify the sum of the count of the two target tables is equal to the count of the source table?
- In the Local Object Library Data Flow tab, right click the Alpha_AuditCustomer_DF data flow and choose Audit
- On the Label tab of the Audit dialog, right click Alpha_Other_customer and choose Count.
- Save all changes
- In the Audit editor, choose the Rule tab.
Reveal Solution Next Question