Create a Mart Hierachy Flatten

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

What is a Mart Hierarchy Flatten

In a Data Vault model, a Mart Hierarchy Flatten transforms complex, multi-level source hierarchies into a single, flat target table.

This approach resolves the "Bill of Material (BOM) explosion" problem by storing all hierarchical relationships in a simplified structure, making data easier to query and manage.

It eliminates the need to repeatedly traverse nested levels, improving performance and clarity in reporting.

Use case example

The use case is similar to the Hierarchy Flatten, but for Business Vault Layer Model Objects as the source.

Creation steps

There is one possibility for creating a Mart Hierarchy Flatten Model Object:

• Create a Model Object manually:
  
  • Create a Model Object of type Mart Hierarchy Flatten in the Datamart Layer
  • Create a Dataflow Set 
  • Add a Model Object to the Dataflow Set: add twice the Business Current View Model Object

• • • Add a Join expression between the two Business Keys
  • Automap:
    • The child Business Key from the first Business Current View
    • The parent Business Key from the second Business Current View

Properties

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

• Implementation Type

• File format (Only for Spark Generator)

Default Terms

A Hierarchy Flatten  Model Object will include the following Default Terms:  

• BG_LoadTimestamp

• BG_SourceSystem