Object Registration and Validation

3.7 Object Registration and Validation

Table Classifications provide a means to designate how tables are used within the OFSAA suite of applications. Each table classification identifies a specific purpose for which an assigned table is allowed to be used.

Some Table Classifications have requirements that must be satisfied in order for an object to be assigned to the classification. These requirements are designated by Table Properties associated to the Table Classifications. These Table Properties are either specific column name requirements or logic validations.

Table Classification assignments are stored in REV_TABLE_CLASS_ ASSIGNMENT.

Note:

FSI_D_CUSTOMER table should be registered against Other table Class and Profitability-Other Class in REV_TABLE_CLASS_ASSIGNMENT table. Below SQL statements should be executed explicitly to make the required entries in REV_TABLE_CLASS_ASSIGNMENT :

 Insert into
                REV_TABLE_CLASS_ASSIGNMENT
                (TABLE_NAME,OWNER,TABLE_CLASSIFICATION_CD,PROTECTED_FLG,VALIDATED_FLAG) values
                ('FSI_D_CUSTOMER','<DB OWNER>',30,0,'Y'); Insert into REV_TABLE_CLASS_ASSIGNMENT
                (TABLE_NAME,OWNER,TABLE_CLASSIFICATION_CD,PROTECTED_FLG,VALIDATED_FLAG) values
                ('FSI_D_CUSTOMER','<DB OWNER>',350,0,'Y');

where

<DB OWNER> is atomic schema user name.

Object Registration is a process of classifying a table with one or more table classifications depending on the purpose of the table. This step is performed within the ERwin model by setting various User Defined Properties for a client data object. Validation procedure validates table class assignment for a client data object and needs to be executed after model upload operation.

Topics: