5.6.5 Executing T2T Data Movement Tasks

Before executing T2T data movement tasks, user should ensure that all the dimension tables that are required for instruments data are loaded.

1. The following are some of the mandatory dimensions:
   DIM_ACCOUNTS
   DIM_PRODUCTS_B
   DIM_GENERAL_LEDGER_B
   DIM_COMMON_COA_B
   DIM_ORG_UNIT_B
2. Create a new Batch with the Task
3. Specify the following parameters for the task for loading Historical Exchange Rates:
   Datastore Type: Select appropriate datastore from the drop down list.
   Datastore Name: Select appropriate name from the list. Generally it is the Infodom name.
   IP address: Select the IP address from the list.
   Rule Name: Select the appropriate T2T name from the above list.
   Parameter List: No Parameter is passed. The only parameter is the As of Date Selection while execution.
4. Check T2T component logs and batch messages for checking the status of load.
   T2T component can fail because of following cases:Unique constraint error:
   Target table may already contain the primary keys that are part of the staging tables.
   NOT NULL constraint error: do not have values for NOT NULL columns in the target table.