Question 31
You create a file format in SAP Data Services
What properties can you set for a column?
Note: There are 3 correct answers to this question.
What properties can you set for a column?
Note: There are 3 correct answers to this question.
Question 32
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?
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?
Question 33
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 the Alpha_AuditCustomer_DF to the Alpha_AuditCustomer_Job .
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 the Alpha_AuditCustomer_DF to the Alpha_AuditCustomer_Job .
Question 34
________for the user account through which SAP
Data Services connects to this SAP application server.
Data Services connects to this SAP application server.
Question 35
What does the expression SUBSTR(FIRST NAME, 1,3) return?
