Create a Mart Composite

A Model Object of type Mart Composite can be created in the Datamart Layer.

What is a Mart Composite

A Mart Composite is a free-style data mart modeling that should provide a particular perspective on top of a data vault, a dimensional or a relational model for front-end tools (like views for multidimensional cubes).

Creation steps

There are two possibilities to create a Mart Composite Model Object:

• Create a Model Object with the Wizard:
  • Recommended possibility
  • Use the Wizard Create a Mart Composite from a Raw Vault or a Business Vault Composite that contains the following steps:
    • Create Model Object
    • Create Dataflow
    • Map selected Terms: exclude the Business Key(s) = {true}, exclude the Foreign Key(s) = {true}
    • Add to View
• Create a Model Object manually:
  
  • Create a Model Object of type Mart Composite in the Gold Layer
  • Create a Dataflow Set 
  • Add a Model Object to the Dataflow Set: add the needed Model Object(s) from the Raw Vault Layer
  • Auto-map the Source Terms: select the auto-map mode and auto-map all the needed Source Terms from the Source Model Object

Properties

A Mart Composite Model Object can be configured through the following Properties:

• Implementation Type

• Deduplication Method

• Deduplication Partition

Default Terms

A Mart Composite Model Object will include the following Default Terms:

• BG_LoadTimestamp

• BG_SourceSystem

Business Rules

The following Business Rules are checked during the Model Object creation:

• Dataflows amount: min = {1}, max = {null}
• Dataflow Sets amount: min = {1}, max = {null}
• Dataflow Set Model Objects amount: min = {1}, max = {null}
• Relationships amount: min = {null}, max = {0}
• Terms amount: exclude Default Terms = {true}, exclude Business Keys = {false}, exclude Identities = {false}, exclude Foreign Keys = {false}, exclude unmapped Terms = {false}, min = {1}, max = {null}
• Supported Term Data Types: exclude Default Terms = {true}, exclude Business Keys = {false}, exclude Identities = {false}, exclude Foreign Keys = {false}, exclude unmapped Terms = {false}
• Supported Term Data Types: exclude unmapped Terms = {true}, Term name = {IncrementalFilter}
• Supported Implementation Types: supported Implementation Types = {Cached, Virtual}
• Implementation Type Incremental Filter
• Supported Deduplication Methods: supported deduplication Methods = {None, Distinct, Partition}