Party Dimension table stores history of a Party. A Party here can be a customer, issuer, guarantor, etc.
|
NOTE |
Party Dimension table must be populated before populating any other Party related Dimension table. Following are the two customer based dimensions that are used across various OFSAA applications for their processing and reporting requirements: · DIM_PARTY · DIM_CUSTOMER In the current release, data is sourced from STG_PARTY_MASTER to the above Dimension tables. |
To address the Bug 20486362 - SCD TO POPULATE DIM_CUSTOMER FROM STG_PARTY_MASTER TO BE ADDED, a new SCD (MAP_REF_NUM = 335) was introduced in OIDF release 8.0.1.0.0 to load DIM_CUSTOMER using STG_PARTY_MASTER and STG_PARTY_ROLE_MAP as the source. Customers, who use applications that have a dependency on DIM_PARTY, are advised to use this SCD instead of SCD-32. Execute batch DIM_CUSTOMER_SCD_PARTY to populate DIM_CUSTOMER using STG_PARTY_MASTER and STG_PARTY_ROLE_MAP as the source. SCD-32 is planned to be deprecated in a future release.