You are joining tables using the query transform of SAP Data Services.

From the account table you want to know how many accounts you have per account type. The ACCOUNT_TYPE is output along with an additional column COUNTER. The group by tab of the query transform is used with ACCOUNT_TYPE. Which mapping would you use for the COUNTER column in SAP Data Services?

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?

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?

Which of the following administrative tasks can you perform using the SAP Data Services Management Console?