To write complex transformation logic using the flexibility of the scripting language.

To perform job initialization tasks to print the job variable values into the trace log using the print() function.

To set the desired properties, for example, trace options, monitor sample rate, and the use statistics for optimization flag.

To execute single SQL commands using the sql() function to select a value from a status table for the variable.

count_distinct(Account_TYPE)

Count(*)

count(Account_type)

Gen_Row_Num()

query

Key generation

Map operation

History Preserving

The rows for a given date range

The current date for a column to see when each row was loaded.

the valid from date based on a dataset the contains valid to information only

the valid to date based on a dataset the contains valid to information only

To ensure that all objects of the workflow are executed during recovery including the steps that were executed successfully in the prior run

To ensure that the workflow is skipped during recovery if the workflow was executed successfully in the prior run.

To ensure that all dataflow of the workflow are executed in one single transaction during recovery

To ensure that each dataflow is recovered as a separate unit during the recovery execution

U

M

FIR

IRS

They are flagged for later deletion

They are deleted from the target

They are added to the overflow file

They are filtered by the transform