35.2 Additional Configurations for User defined Metadata and Application Integration

The lineage execution will happen for the data flow which are configured FSI_DE_POP_RUN_LIST and FSI_DE_POP_RUN_RELATIONSHIP tables. Users can configure these two tables for getting the metadata lineage for user-specific runs.

Enabling Run for METADATA Parsing

Every execution for METADATA Parsing requires a minimum of one Run to be enabled in the FSI_DE_POP_RUN_LIST table in the Atomic Schema. By default, FSDF_EXE_RUN is enabled.

Table 35-2 Run Names for Metadata Parser

RUN NAME	INCLUDE RUN
FSDF_EXE_RUN	Y

Configuring prerequisite Run/ Batch

The pre-requisite data flow for FSDF EXE run is identified using records available in FSI_DE_POP_RUN_RELATIONSHIP. By default, FSDF run chart is seeded. For any additional data flow, the additional records can be inserted into this table, for the data flow to be considered during lineage execution.

Table 35-3 Run Names for Metadata Parser

RUN NAME	REL RUN NAME	PROCESSING OUTPUT FLAG
FSDF_EXE_RUN	<INFODOM>_POP_DATES_DIM	N
FSDF_EXE_RUN	<INFODOM>_DIM_ACCOUNT_SCD	N
FSDF_EXE_RUN	<INFODOM>_DATA_FOUNDATION_SCD	N
FSDF_EXE_RUN	<INFODOM>_DATA_FOUNDATION_SCD_MLS	N
FSDF_EXE_RUN	<INFODOM>_POP_KEY_DIMENSION_SCD	N
FSDF_EXE_RUN	<INFODOM>_PARTY_MAPPER_SCD	N
FSDF_EXE_RUN	FSDF_MAPPER_RUN	N
FSDF_EXE_RUN	FSDF_SOURCE_RUN	N

Excluding Irrelevant Data Flows from Lineage Reports

For each Run, some of the Data Mappings can be functionally irrelevant. For these cases concerning any Run, the customer can opt for removing these Data Flow from Lineage Reports as an exclusion by inputting the same in the FSI_DE_RUN_FLOW_REMOVAL table.

Execution Types for METADATA Parsing in <INFODOM>_POP_DATA_ELEMENTS_FSDF Batch

1. Full METADATA Parsing [Default Mode] (if the P_FULL_PARSE parameter is ‘Y’, then the parsing happens for the entire METADATA and Run Elements for the Run(s) enabled in FSI_DE_POP_RUN_LIST table in the Atomic Schema).
2. Incremental METADATA Parsing [Optional Mode. Batch Parameter to Be Modified] (if the P_FULL_PARSE parameter is ‘N’, then the parsing happens for changed METADATA and Run Elements for the Run(s) enabled in FSI_DE_POP_RUN_LIST table in the Atomic Schema).

   You can edit the parameters by accessing the Batch Maintenance screen.

   1. Log in to Oracle Financial Services Analytical Applications interface with your credentials.
   2. Navigate to Financial Services Data Foundation, select Operations, and then select Batch Maintenance.
   3. Select Batch Name (<INFODOM>_POP_DATA_ELEMENTS_FSDF)
   4. (OPTIONAL) Select Task1 and click the Edit button. The Edit Task Definition Window is displayed.
   5. Modify the Parameter List field as applicable.