C_DS_42 SAP Certified Application Associate - Data Integration with SAP Data Services 4.2 Questions and Answers

Debug a dataflow to find data issues

Display the optional Validation Transform statistics

View the rows and the values being loaded

Schedule a job for daily execution

Display trace and monitor and error logs.

Type: Delimited column delimiter:; skip row headen: no

Type: Fixed column length:4,2 and 6 skip row headen: yes

Type: Delimited column delimiter:; skip row headen: yes

Type: Delimited column delimiter: skip row headen: yes

The complete metadata information of the table

Only the table name

The whole table with all its source data

The table name and all column names with their dataypes.

You can see which rules were violated in one output

You can set different failed paths for each rule

You can have multiple rules on a single column.

You can produce statistics

You can call a recovery dataflow

default value

Format information

field size

data type

comment

Click the view enabled descriptions button on the toolbar.

Enter a description in the properties of the object.

right-click the object then choose enable description .

Right - click on the job in the project hierarchy to enable all descriptions.

disiable the hide non - executable elements setting in the difference viewer.

Use a script with an SQL function to read from status table

Use a catch block and set the variable to 'yes1

Use a dataflow to set the value via a template table

Use a global variable to persist the value across job executions

Before the pivot transform

Between the pivot transform and the query transform

After the query transform

Before the pivot transform and after the query transform.

To define a connection to SAP HANA

To reduce the memory consumption in the target database.

To reduce the memory consumption in the source database.

To enhance processing performance of datadlows used in real time jobs.