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.

This topic contains the following subtopics: