5.8 DIM_Party Population

DIM_party holds customer level details. STG_PARTY_MASTER is the source table for Dim_party. Party_skey uniquely identifies the customer records.

Execution from ICC Batch

Create a new Batch with the Task and specify the following parameters for the task for loading DIM_Party:

  • Component: Run Executable
  • Datastore Type: Select appropriate datastore from list
  • Datastore Name: Select appropriate name from the list
  • IP address: Select the IP address from the list
  • Executable: scd,168
  • Wait: N
  • Batch Parameter: Y

Note:

Instrument tables to instrument Summary T2T pulls the customer related information from Dim party. So, populating Dim party should be done prior to T2T run from Instrument to Instrument Summary T2T execution.