Create a Mart Out

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

What is a Mart Out

A Mart Out is a free-style modeling object that provides a particular perspective on top of the other data mart model objects for specific consumers or front-end tools (like views for multidimensional cubes).

It represents an transformative object which can use model objects from the Data Mart layer as sources. 

Creation steps

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

• Create a Model Object with the Wizard:
  • Recommended possibility
  • Use the Wizard Create a Mart Out from a Mart Fact, Mart Entity, Mart Composite or Mart Out 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 Out in the Gold Layer
  • Create a Dataflow Set 
  • Add a Model Object to the Dataflow Set: add the needed Model Object(s) from the Mart 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 Out Model Object can be configured through the following Properties:

• Implementation Type

• Deduplication Method

• Deduplication Partition

Default Terms

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

• BG_LoadTimestamp

• BG_SourceSystem