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 Construct an audit rule that an exception must be entered into the log if the count from both tables is not the same.

• A.On the Label tab, right click the target table, Alpha_NA_customer , and choose Count .
• B.Under Action on failure, select the Raise exception checkbox.
• C.Choose Close .
• D.In the operator drop down list, choose the operator equal (=).
• E.In the right drop down list, choose the audit label $count_Alpha_NA_customer for the target table.
• F.In the Rule tab, under Auditing Rules , choose Add .

Comment: *

Name: *

Email: *

Verification: *

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 Save all changes and execute the job with auditing enabled and Trace Audit Data set to Yes.

• A.In the Value field, using the drop down list, change the value to Yes .
• B.Right-click the Alpha_AuditCustomer_Job and choose Execute .
• C.In the Trace tab, choose Trace Audit Data .
• D.Choose Add and select Custom.
• E.In the Execution Properties dialog box, in the Execution Options tab, select the Enable auditing checkbox.
• F.To remove the existing audit rule, choose Delete

Comment: *

Name: *

Email: *

Verification: *