Create a Store Composite

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

What is a Store Composite

A Store Composite represents an intermediate object that holds temporary data to build readable and traceable mappings.

Often, they represent a sub-select or common table expression (CTE).

They can contain joins, aggregation, expressions, filters, and default values.

Use case example

Source data

We will use this Model Object Type to split our sales data into reseller and internet sales.

Our source data are from the Stage SalesOrderHeader.

The Term OnlineOrderFlag lets us distinguish between resellers and the internet in sales.

Let's create a Store Composite with the Wizard from the Stage SalesOrderHeader:

Rename it SC_ResellerSales.

Add the following where clause for the Set1:

s1.OnlineOrderFlag = 0

Load of data

The resulting view after the data load is:

Only the sales from resellers are included in the view.

Creation steps

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

• Create a Model Object with the Wizard:
  • Recommended possibility
  • Use the Wizard Create a Store  Composite from a Stage or a Store Composite that contains the following steps:
    • Create Model Object
    • Create Dataflow
    • Map selected Terms
    • Add to View
• Create a Model Object manually:
  • Not recommended possibility
  • Create a Model Object of type Store Composite in the Bronze 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 to create the Target Terms and map them to the Source Terms

Properties

A Store Composite Model Object can be customized through the following Properties:

• Implementation Type

Default Terms

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

• BG_LoadTimestamp

• BG_SourceSystem