C_DS_43 試験問題を無料オンラインアクセス

What does the data services repository of SAP Data services contain?
There are 2 correct answers to this question

• A.Transformation rules
• B.Target metadata
• C.User security
• D.in flight data

You built a delta load dataflow in SAP Data Services. This Dataflow is executed every night. The source table contains a CHANGE_DATE column which is populated by the database when the row is saved.
What can a timestamp based CDC aproach identify in the source based on this CHANGE_DATE column

• A.Insert, updates and deletes for a specified time range.
• B.Every single change made to a row
• C.Inserted and updated rows but not delete rows
• D.Update rows but NOT insert or deleted records.

What errors can you handle in SAP Services when you use a file format target?

• A.File type error
• B.Semantic error
• C.Data type conversion error
• D.Row- format error

An SAP data services file format has a date column, but occasionally the file contains an invalid value in one row. This causes the dataflow to terminate with an error.
What can you do to completely load such erroneous files?
Note: There are 2 correct answer

• A.Use the error handling options for conversion error in the file format definition
• B.Define the column as varchar and use functions in subsequent Query transform to perform the checks and conversion
• C.Place the dataflow between a Try/Catch block to catch all erroneous rows
• D.Specify a date format of'????-??-??' to indicate the value might NOT be a valid date in the file format editor

You are asked to perform either the initial load or delta load based on the value of a variable that is set at job execution How do you design this requirement in SAP Data services.

• A.Use a job containing a Case transform testing for the two possible conditions. Connect one case output to the initial dataflow and the other to the delta dataflow Use a job container the delta dataflow
• B.Use a job containing a script with the if then else () function to test the variable value. Connect this script to the initial and delta u dataflow.
• C.Set the job to call the initial and delta dataflow in parallel. Each dataflow should have a filter testing for the variable value.
• D.Use a job containing a Conditional objet that test the value of the variable. In the IF part, call the initial dataflow in the ELSE part call