In OFSAA DIH Application, the uploaded data model is visible as Application Data Interface (ADI). These ADI names are given through erwin data model entity UDP for each table. For any new table addition which is added as part of customization should have valid value in following entity UDPs to get the proper ADI names in DIH.
· OFSAA Data Interface Name: This Entity UDP expects the logical name of the table or logical name for a group of tables which will be displayed as an ADI in DIH. This UDP is mandatory for all Stage and Results tables to get a valid ADI in DIH which corresponds to each table in model.
· OFSAA Data Interface Subtype: This Entity UDP expects the logical name of a table where the table is part of a group of tables where we have a group name in OFSAA Data Interface Name UDP. This UDP is optional and applicable only if you have a one OFSAA Data Interface Name against a group of tables.
For Example:
· STG_CASA, STG_LOAN_CONTRACTS, STG_TD_CONTRACTS, FCT_COMMON_ACCOUNT_SUMMARY are defined as group of tables and the UDPs for the tables are given in the following table:
TABLE_NAME |
OFSAA Data Interface Name |
OFSAA Data Interface Subtype |
STG_CASA |
Customer Account |
CASA Contracts |
STG_LOAN_CONTRACTS |
Customer Account |
Loan Contracts |
STG_TD_CONTRACTS |
Customer Account |
Term Deposits |
FCT_COMMON_ACCOUNT_SUMMARY |
Customer Account |
Common Account Summary |
· If you have Stage and Fact tables for the same purpose, you need to define it as same name given for OFSAA Data Interface Name, OFSAA Data Interface Subtype.
TABLE_NAME |
OFSAA Data Interface Name |
OFSAA Data Interface Subtype |
STG_ACCT_FEATURE_MAP |
Account Feature Map |
Account Feature Map |
FCT_ACCOUNT_FEATURE_MAP |
Account Feature Map |
Account Feature Map |
· If you have independent tables like only one either stage or dim or fact, then Subtype can be left blank.
TABLE_NAME |
OFSAA Data Interface Name |
OFSAA Data Interface Subtype |
STG_VEHICLE_MASTER |
Vehicle Master |
|
FCT_TXN_CHANNEL |
Transaction Channel |
|
DIM_ACCOUNT |
Account Dimension |
|