C-DS-42 무료 덤프문제 온라인 액세스

You have to load a file that contains the following first three lines:
YEAR; MONTH; PLAN_AMOUNT
2014;01;100.00
2014;02;110.00
What setting do you use when you created a file format for this?

• A.Type: Fixed column length:4,2 and 6 skip row headen: yes
• B.Type: Delimited column delimiter:; skip row headen: yes
• C.Type: Delimited column delimiter:<blank> skip row headen: yes
• D.Type: Delimited column delimiter:; skip row headen: no

A target column named ZIP4 requires the input of the source columns: POSTCODE and EXTENSION. For example:
POSTECODE:99999
EXTENSION: 9999
Desired result is ZIP4:99999-9999

• A.POSTCODE ||'-'|| EXTENSION
• B.rpad_ext(POSTCPDE,EXTENSION)
• C.POSTCODE AND '-' AND EXTENSION
• D.POSTCODE +'-*+ EXTENSION

You executed a job in development environment and it raised primary key violation error in SAP Data Services. Which feature do you enable to identify which primary key values caused the errors?

• A.delete data before loading
• B.Use overflow file
• C.Auto correct load
• D.Drop and re-created target table

In SAP data services what does the date generation transform allow you to generate?

• A.the valid from date based on a dataset the contains valid to information only
• B.The current date for a column to see when each row was loaded.
• C.The rows for a given date range
• D.the valid to date based on a dataset the contains valid to information only

What task can you perform in the SAP Data Services Management Console? Note: There are 3 correct answers to this question

• A.Schedule a job for daily execution
• B.View the rows and the values being loaded
• C.Display trace and monitor and error logs.
• D.Debug a dataflow to find data issues
• E.Display the optional Validation Transform statistics