Create a Core Composite

A Model Object of type Core Composite can be created in the Silver Layer.

What is a Core Composite

A Core 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 Core 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 Core Composite Model Object:

• Create a Model Object with the Wizard:
  • Recommended possibility
  • Use the Wizard Create a Core Composite from a Stage or a Core 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 Core Composite 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 to create the Target Terms and map them to the Source Terms

Properties

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

• Implementation Type

Default Terms

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

• BG_LoadTimestamp

• BG_SourceSystem