8       Configuring Entity UDPs for Application Data Interface of Data Integration Hub

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