Hello friends, Today I am going to blog a post how to create Tables in MDM Hub Console. There are mainly three Tables needed for performing data Consolidation through Raw data to Target Data. The Tables Names are Base Object Table, Landing Table, Staging Table.

Procedure to Make Base Object Table (Target Data Table):

1. In the Workbench, Click on Schema ->Select Database ->Base Objects 
2. Click Write Lock(w) ->Acquire Lock (A) Add Base Object  with ADD Item
3. Give The Name “BO Sales” and Click On BO Sales
4. Click On Column Add the required Filed in the Table And Save It.
5. This completed with the Base Object Table.

Procedure to Make Staging Table (Temporary Table):

1. Let us  Suppose that we need to create 3 Staging Table (depends according To the Source System)
2. In the Workbench, Click on Schema ->Select Database ->Base Objects ->BO Sales ->Staging Table
3. Click Write Lock(w) ->Acquire Lock (A) Click On Staging Table with ADD Staging Item
4. Add The System according to the “Source System” in System Trust.
5. Put the System name.
6. Add The System according to the “Source System” in System Trust
7. Similarly Add ST Sales2 and ST Sales3

Procedure To Make Landing  Table(Raw Data Table)

1. In the Workbench, Click on Schema ->Select Database ->Landing Tables
2. Click Write Lock(w) ->Acquire Lock (A) Click On Landing Table with ADD Landing Item
3. Now you can Import Column Name By select Import Schema on Right Side Put the Login  Entries In SQL DataBase Server and Select BO Sales. Through this we can select all columns
4. Click on Next and Select BO Sales and Finish
5. Select the Column and Save.
6. Add One More Column Name “Source System” in Landing Table
7. Click On save Now you have Created the Landing Table