C_DS_42 Exam Question 21
When evaluating the customer data for Alpha Acquisitions, you discover a data entry error.
The contact title of "Account Manager" has been entered as "Accounting Manager".
You must correct these entries before it is moved to the data warehouse.
How to In the Alpha_NACustomer_DF workspace, delete an existing expression for the Title column in the Query transform.
The contact title of "Account Manager" has been entered as "Accounting Manager".
You must correct these entries before it is moved to the data warehouse.
How to In the Alpha_NACustomer_DF workspace, delete an existing expression for the Title column in the Query transform.
C_DS_42 Exam Question 22
In the workspace for Alpha_NACustomer_DF , How to add the customer table from the Alpha datastore as the source object?
C_DS_42 Exam Question 23
The performance of a dataflow is slow in SAP Data Services.
How can you see which part of the operations is pushed down to the source database? Note: the are 2 correct answers to this question.
How can you see which part of the operations is pushed down to the source database? Note: the are 2 correct answers to this question.
C_DS_42 Exam Question 24
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.
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.
C_DS_42 Exam Question 25
You source table has a revenue column and a quantity column for each month. You want to transform this data to get a table containing twelve rows whit two columns.
What is the best way to achieve this in SAP Data services?
What is the best way to achieve this in SAP Data services?
