4.2.4 Output Tables

The equivalent output tables exist in CSA according to the input tables for the respective pipelines.

For example, if the input table is STG_PARTY_MASTER_PRE, the output table will be STG_PARTY_MASTER. It is the same for FSDF 8124, 8125, 8126, 8128 and 8128.

After executing the Data survival Job, the output tables store the corresponding global party data.

Note:

• By default, the output tables are available in FSDF. The purpose of the tables is the same as the input tables.
• Regardless of Full load or Delta load, the output tables contain the complete set of records with the current fic_mis_date. Such global parties can be removed from output tables where mappings have changed, and parties are deactivated.

The following are the output tables:

• STG_PARTY_MASTER
• STG_PARTY_DETAILS
• STG_PARTY_EMAIL_MAP
• STG_PARTY_ADDRESS_MAP
• STG_ADDRESS_MASTER
• STG_PARTY_PHONE_MAP
• STG_CUSTOMER_IDENTIFCTN_DOC