35.1 Prerequisites

The following executions must be performed before using the Metadata Export Utility:

1. Before executing MDB Publish and Data Elements Wrapper Batch (<INFODOM>_POP_DATA_ELEMENTS_FSDF), ensure the following:
   1. Tablespace Requirement:
      1. Ensure that the USERS tablespace have a minimum of 100 GB available
      2. Ensure that the TEMP tablespace is a minimum of 45 GB available
   2. Execute the following Gather Stat command for the mentioned tables:

      BEGIN

      DBMS_STATS.GATHER_TABLE_STATS(USER, 'TABLE_NAME');

      END;

      1. Config Schema:
         • AAI_OBJECT_B
         • AAI_OBJECT_TL
         • AAI_DMT_DEFINITION
         • AAI_DMT_DEF_SOURCE_ENTITY
         • AAI_DMT_MAPPING_DETAILS
         • PR2_RULES_B
         • PR2_RULE_MAP
         • PR2_RULE_OBJECT
         • PR2_RULE_OBJECT_MEMBER
         • PR2_OBJECT_TL
         • PR2_OBJECT_TRACE
         • BATCH_MASTER
         • BATCH_TASK_MASTER
         • BATCH_PARAMETER_MASTER
         • METADATA_MASTER
         • METADATA_ELEMENT_MASTER
         • METADATA_LOCALE_MASTER
         • METADATA_TYPE_MASTER
         • METADATA_ATTRIBUTE_MASTER
         • AAI_WF_PROCESS_B
         • AAI_WF_PROCESS_TL
         • AAI_WF_ACTIVITY_B
         • AAI_WF_ACTIVITY_TL
         • AAI_WF_APPLICATION_API_B
         • AAI_WF_APPLICATION_API_TL
         • AAI_WF_DATA_FIELD_B
         • AAI_WF_DATA_FIELD_TL
         • AAI_WF_ACTIVITY_TASK_B
         • AAI_WF_ACTIVITY_TASK_TL
         • AAI_WF_TRANSITION_B
         • AAI_WF_TRANSITION_TL
         • AAI_WF_ACTIVITY_TASK_USER_MAP
         • AAI_WF_ACTUAL_PARAMS
         • AAI_WF_ACTIVITY_SUBPROCESS
         • AAI_WF_ATTR_COMPONENT
         • AAI_WF_ATTR_COMP_VAR_MAPPING
         • AAI_WF_PROCESS_DETAIL_FILTER
         • AAI_WF_PROCESS_FILTER
2. Navigate to Financial Services Data Foundation, select Metadata Browser.
3. Click Publish: Execute the batch, INFODOM_MDB.
4. After performing an MDB Publish and executing the Data Element Wrapper Batch, ensure the following:
   1. Execute the following Gather Stat command for the mentioned tables:

      BEGIN

      DBMS_STATS.GATHER_TABLE_STATS(USER, 'TABLE_NAME');

      END;

      1. Atomic Schema:
         • FSI_DE_RUN_LINEAGE_METADATA
5. Logs: MDB logs are generated under deployed area

   /Context_Name/logs/MDB_Publish_XXXX.log

6. Data Elements Wrapper Execution : After MDB Publish is completed successfully with the message “Metadata publishing is finished.” in the /Context_Name/logs/MDB_XXXX.log, you must execute the Data Elements Utility with the following seeded batch to get the Data Lineage for each Metadata in OFSAA:

   <INFODOM>_POP_DATA_ELEMENTS_FSDF

   This execution requires adequate tablespace. Ensure that your Atomic Schema is having enough tablespace in TEMP and USERS.

   Parameters used in <INFODOM>_POP_DATA_ELEMENTS_FSDF Batch

   The batch can be executed in different modes according to each requirement. The following are the parameters used for executing the batch.

   The default parameters used in the <INFODOM>_POP_DATA_ELEMENTS_FSDF batch are:

   Table 35-1 Task1 (METADATA PARSER)

   Sl. No.	Parameter	Description	List of Values	Default Value
   1	P_FULL_PARSE	Full Parser Flag	Y/N	‘Y’
   2	P_INFODOM_NAME	Infodom Name	##INFODOM##	<Value of the Infodom where FSDF is installed>. For example: ‘FSDFINFO’