QUESTION: 1

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 Replicate the Audit_NACustomer_DF data flow?

In the Local Object Library Data Flow tab right click the Alpha_NACustomer_DF data flow and choose Replicate
Rename the copied data flow Alpha_AuditCustomer_DF.
Right click the Omega project in the Project Area.
Choose New Batch Job
Name the new job Alpha_AuditCustomer_Job.

Answer(s): A,B

Reveal Solution Next Question

QUESTION: 2

How to Save and execute the Alpha_NACustomer_Job?

In the main menu, choose Project Save All & To save all changes, choose OK
In the Project Area, right click the Alpha_NACustomer_Job and choose Execute & to accept the default execution properties, choose OK
To return to the Job workspace, in the tool bar, choose the Back icon & to return to the Data
Flow workplace, double click the Data Flow.
In the Query editor, choose the WHERE tab

Answer(s): A,B,C

Reveal Solution Next Question

QUESTION: 3

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 create a new batch job Alpha_AuditCustomer_Job?

In the Local Object Library Data Flow tab right click the Alpha_NACustomer_DF data flow and choose Replicate.
Rename the copied data flow Alpha_AuditCustomer_DF.
Right click the Omega project in the Project Area.
Choose New Batch Job
Name the new job Alpha_AuditCustomer_Job.

Answer(s): C,D,E

Reveal Solution Next Question