Configuration Guide

10.3 HotFix 2

Back Next

Process Overview for Defining Base Objects

Use the Schema Manager to define base objects.

Using the Schema Manager, create a base object table.

The Schema Manager automatically adds system columns.

Add the user-defined columns that will contain business data.

Column names cannot be longer than 26 characters.

While configuring column properties, specify the columns that will use trust to determine the most reliable value when different source systems provide different values for the same cell.

For the base object, create one staging table for each source system. For each staging table, select the base object columns that you need to include.

Create landing tables that you need to store data from source systems.

Map the landing tables to the staging tables.

If any column needs data cleansing, specify the cleanse function in the mapping.

Each staging table must get its data from one landing table (with any intervening cleanse functions), but the same landing table can provide data to more than one staging table. Map the primary key column of the landing table to the PKEY_SRC_OBJECT column in the staging table.

Populate each landing table with data using an ETL tool or some other process.

Configuring Base Objects

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal