Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring Common Components of the Siebel Customer-Centric Enterprise Warehouse > Configuring Loads >

Joining Objects in the Staging Area

If you want to join objects from multiple tables, you can do so in the Staging Area. This section describes how to join objects in the Staging Area by configuring the load mapping.

To join staging tables in the Staging Area

1. In PowerCenter Designer, open the applicable source system configuration folder.
2. Open the applicable load mapping.
3. Copy the table you want to add to the load mapping by dragging and dropping it into the mapping definition in Mapping Designer.

   Perform this step for all tables you want to join in the Staging Area.

4. Drag and drop the columns you wish to join from the source definition to the Source Qualifier.
5. Double-click the Source Qualifier transformation to open the Edit Transformations box, and select the Properties tab.
6. Select the small arrow in the Value column to open the SQL Editor.
7. Edit the SQL statement to add the join conditions between the new table and the existing table in the mapping.
8. Drag and drop those columns from the Source Qualifier to the respective ports in the Source Adapter mapplet.
9. Validate and save your changes to the repository.