1. User Guide
  2. Metadata Report
  3. Prerequisites
  4. Validating Lineage Outputs

17.1.2 Validating Lineage Outputs

In Atomic Schema, you must verify that data is present in the following tables and ensure that the table is populated:

  • FSI_DE_RUN_LINEAGE_METADATA
  • MDR_LINEAGE_METADATA
  • FSI_DE_REPORT_LINEAGE_BASE
  • FSI_DE_REPORT_LINEAGE_DETL
  • FSI_DE_DATA_FLOW_MAPPINGS
  • FSI_DE_RUN_FLOW_MAPPINGS

It is recommended that the following SQL statement must be executed in Config Schema if this INDEX is not created:

CREATE INDEX index_mdr_mod_parent_child
ON mdb_object_dependencies(parent_object_def_id,child_object_def_id)
COMPUTE STATISTICS
/