C_DS_42 Sample Questions Answers

Set the job to call the initial and delta dataflow in parallel. Each dataflow should have a filter testing for the variable value.

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.

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

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

a local variable in a workflow sets the value of an a parameter in a dataflow.

3 local variable in a job sets the value of an a parameter in a workflow

a parameter in a workflow sets the value of a local variable in a dataflow

a parameter in a job set the value of a local variable in a dataflow

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.

by setting the target table loader with Bulk Load and Auto Correct Load enabled.

by setting the target table loader with bulk load enabled

By using the table comparison transform

By creating two dataflows and executing the Auto Correct Load version when reired

Match_Pattern

Decode

Literal

Match_regex

workflow

subdataflow

JOB

Dataflow

Embedded dataflow

In the table reader

In a table loader

In a query transform

In the Map transform

Drag one column from the input schema to the output schema

Select an output column and enter the mapping manually.

Drag one column from the output schema to the input schema

Select one input column and enter the mapping manually

The job executes the scripts if it is part of a workflow marked as a recovery unit, but only if an error was raised

The job executes the scripts if it is part of a workflow marked as a recovery unit irrespective of where the error ocurred in the job flow.

the job starts with the flow that caused the error. If this flow is after the initialization script the initialization script is skipped.

The job reruns all workflows and scripts. When using automatic recovery, only dataflows that ran successfully in the previous execution ^ are skipped.