Create a Store Entity

A Model Object of type Store Entity can be created in the Bronze Layer.

What is a Store Entity

In Data Store modeling, a Store Entity represents a structural object.

It must have a set of business keys to identify a unique data entry.

It usually contains the whole data history from a Stage Model Object with a delete detection behavior, for example.

Creation steps

There are two possibilities to create an Store Entity Model Object:

• Create a Model Object with the Wizard:
  • Recommended possibility
  • Use the Wizard Create Store Entity from a Stage or a Store Composite that contains the following steps:
    • Create Model Object
    • Create Dataflow
    • Map selected Business Keys
    • Map selected Terms
    • Add to View
• Create a Model Object manually:
  • Not recommended possibility

• • Create a Model Object of type Entity in the Silver Layer
  • Create a Dataflow Set 
  • Add a Model Object to the Dataflow Set: add the Stage Model Object
  • Auto-map the Source Terms: select the auto-map mode and auto-map all the Source Terms in the Source Model Object
  • Set the Business Key

Properties

A Store Entity Model Object can be configured through the following Properties: 

• Delete Detection Method
• Delete Detection Source

• Implementation Type

• Load Caching
• ValidFrom Source Term

Default Terms

A Store Entity Model Object will include the following Default Terms:  

• BG_SourceSystem
• BG_LoadTimestamp
• BG_UpdateTimestamp
• BG_ValidFromTimestamp
• BG_ValidToTimestamp
• BG_IsDeleted
• BG_RowHashScd1
• BG_RowHashScd2