3.20.5 Transport Fact Mapping

This topic describes the information about the transport fact mapping feature.

There is a provision to transport data from other domains to CMC schema and extract facts in batch.

After the table is transported in CMC schema, there are 2 ways in which the <domain>_FACTS table will get enriched with this transported data.

• COLUMN_MAPPING - The _FACTS table is expected to have a column where data from source tables column will be populated directly.
• FLAT_MAPPING - Source tables specific column value is mapped to a facts value in destination table (_FACT table). New row will be created in _FACTS table with the specific factName and value.

In addition, there is a provision to derive the fact value using a transformation class for FLAT_MAPPING. When transformation is enabled, the system executes a seeded SQL query (mapped to the destination fact) and persists the computed result as the fact value.

This topic contains the following subtopics:

• Create Transport Fact Mapping
  This topic describes about systematic instructions on mapping of transport fact.
• Seed Data for Source Table Name
  This topic describes about the seed data for source table name.
• Transformation for FLAT_MAPPING (Computed Facts)
  This topic describes about the Transformation for FLAT_MAPPING (Computed Facts).
• View Transport Fact Mapping
  This topic describes the systematic instructions to view the transport fact mapping.