QUESTION: 5

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.

Answer(s): A,B,D

Show Answer Next Question

QUESTION: 6

You have a Salary table containing departments (DEPARTMENT column) and salaries (SALARY column).
How do you calculate the average salaries for each department in the Query transform in SAP Data Services?

Specify the DEPARTMENT column on the GROUP BY tab.
Enter avg(SALARY) on the Mapping tab.
Enter avg(SALARY) on the SELECT tab.
Specify the DEPARTMENT code on the WHERE tab.

Answer(s): A,B

Show Answer Next Question

QUESTION: 7

Your customer has rules requiring that each row in the source be tested for certain criteria in a specific order.
When a row passes one criteria, it should NOT be tested for the next criteria.
How should this be implemented using SAP Data Services transforms?

Use multiple Query transforms with one WHERE? Clause per rule. Connect all queries to the source; Use a Case transform with the Row Can Be True for One Case; Only and Preserve Expression Order options enabled.
set a Case transform with the Produce Default Output with Label option enabled, and enable the Preserve Expression Order checkbox.
Use a Validation transform and add the rules in the proper order for each single column.

Answer(s): B

Show Answer Next Question

QUESTION: 8

You must calculate the total value of all orders, including their discounts, for reporting purposes.
Currently these details are found in different tables.
Use the sum function to calculate the total value of orders in the Order_Details table.
How to in the transform editor for the Query transform, propose a join between the two source tables?

To open the Query Editor double click the Query.
To connect the Query Transform, select the Query Transform, hold down the mouse button, drag it to the order_sum table, and release the mouse button.
Choose the Where tab or the From tab.
the Propose Join button

Answer(s): A,C,D

Show Answer Next Question

Free SAP C_DS_42 Exam Braindumps (page: 3)

QUESTION: 5

QUESTION: 6

QUESTION: 7

QUESTION: 8

C_DS_42 Exam Discussions & Posts