Task Execution - Overriding Parameters

A task execution can override execution parameters, as follows:

  • Setting the active environment based on the task's environments.
  • Setting key-value parameters on a session level.
  • Overriding Globals values on a session level.
  • Overriding the [Sync Mode]() of the task execution.

Setting Active Environments

Extract Tasks

The TDM Execution process sets the task's environment as the active environment on the executed task.

Load Tasks

The TDM Execution process sets the active environment:

  1. Sets the task's source environment as the active environment.
  2. Gets the LUI from Fabric.
  3. Sets the task's target environment as the active environment.
  4. Runs the delete and/or load flows on the target environment.

Setting Key-Value Parameters

Set execution parameters like replace sequence, delete before load or insert to target indicators. These parameters are based on the task's settings and are set on a session level.

Overriding Globals Values

A project's Globals can be overridden on a TDM environment or TDM task level.

The TDM execution process sets the values on the Globals on a session level.

Note that task level Globals have a higher priority than TDM environment level Globals, i.e. if a Global variable is set on both - the task and the related environment levels - the task's Global value is set.

Overriding the Sync Mode on the Task Execution

When executing a TDM task, set the Sync mode according to the following table:

Override Sync - Source Env Level

Override Sync - Task Level 

Task Operation Mode

Task Execution Sync Mode

Results

None

None

All

On

LUIs are synced according to their sync method. See the Sync Behavior Summary table.

None

Request up-to-date entity

All

Force

LUI are synced from the source.

Always sync

None

All

Force

LUI are synced from the source.

Always sync

Request up-to-date entity

All

Force

LUI are synced from the source.

Do not sync

Request up-to-date entity

All

Force

LUI are synced from the source.

Do not sync

 

 

None

 

 

Insert

Off

  • First sync, return an error.
  • If the LUIs exist in Fabric, get the data from Fabric. 

Delete and insert 

On

  • First sync, return an error.
  • If the LUIs exist in Fabric:
    • Source LU tables, get the data from Fabric.
    • Target LU tables, sync the data from the target environment.

Delete only

On

Target LU tables are synced from the target environment. 

Do not sync

 

 

Do not sync source data

 

 

Insert

Off

  • First sync, return an error.
  • If the LUIs exist in Fabric, get the data from Fabric. 

Delete and insert 

On

  • First sync, return an error.
  • If the LUIs exist in Fabric:
    • Source LU tables, get the data from Fabric.
    • Target LU tables, get the data from the target environment.

None

 

 

Do not sync source data

 

 

Insert

Off

  • First sync, return an error.
  • If the LUIs exist in Fabric, get the data from Fabric. 

Delete and insert 

On

  • First sync, return an error.
  • If the LUIs exist in Fabric:
    • Source LU tables, get the data from Fabric.
    • Target LU tables, get the data from the target environment.

Previous

Task Execution - Overriding Parameters

A task execution can override execution parameters, as follows:

  • Setting the active environment based on the task's environments.
  • Setting key-value parameters on a session level.
  • Overriding Globals values on a session level.
  • Overriding the [Sync Mode]() of the task execution.

Setting Active Environments

Extract Tasks

The TDM Execution process sets the task's environment as the active environment on the executed task.

Load Tasks

The TDM Execution process sets the active environment:

  1. Sets the task's source environment as the active environment.
  2. Gets the LUI from Fabric.
  3. Sets the task's target environment as the active environment.
  4. Runs the delete and/or load flows on the target environment.

Setting Key-Value Parameters

Set execution parameters like replace sequence, delete before load or insert to target indicators. These parameters are based on the task's settings and are set on a session level.

Overriding Globals Values

A project's Globals can be overridden on a TDM environment or TDM task level.

The TDM execution process sets the values on the Globals on a session level.

Note that task level Globals have a higher priority than TDM environment level Globals, i.e. if a Global variable is set on both - the task and the related environment levels - the task's Global value is set.

Overriding the Sync Mode on the Task Execution

When executing a TDM task, set the Sync mode according to the following table:

Override Sync - Source Env Level

Override Sync - Task Level 

Task Operation Mode

Task Execution Sync Mode

Results

None

None

All

On

LUIs are synced according to their sync method. See the Sync Behavior Summary table.

None

Request up-to-date entity

All

Force

LUI are synced from the source.

Always sync

None

All

Force

LUI are synced from the source.

Always sync

Request up-to-date entity

All

Force

LUI are synced from the source.

Do not sync

Request up-to-date entity

All

Force

LUI are synced from the source.

Do not sync

 

 

None

 

 

Insert

Off

  • First sync, return an error.
  • If the LUIs exist in Fabric, get the data from Fabric. 

Delete and insert 

On

  • First sync, return an error.
  • If the LUIs exist in Fabric:
    • Source LU tables, get the data from Fabric.
    • Target LU tables, sync the data from the target environment.

Delete only

On

Target LU tables are synced from the target environment. 

Do not sync

 

 

Do not sync source data

 

 

Insert

Off

  • First sync, return an error.
  • If the LUIs exist in Fabric, get the data from Fabric. 

Delete and insert 

On

  • First sync, return an error.
  • If the LUIs exist in Fabric:
    • Source LU tables, get the data from Fabric.
    • Target LU tables, get the data from the target environment.

None

 

 

Do not sync source data

 

 

Insert

Off

  • First sync, return an error.
  • If the LUIs exist in Fabric, get the data from Fabric. 

Delete and insert 

On

  • First sync, return an error.
  • If the LUIs exist in Fabric:
    • Source LU tables, get the data from Fabric.
    • Target LU tables, get the data from the target environment.

Previous