Configuration Guide

10.4 HotFix 2

Back Next

Mapping Columns

For a direct connection, connect columns from the landing table to columns in the staging table. To cleanse the data coming from the landing table, add a function. The inputs to the function come from columns in the landing table. The output from the function goes to columns in the staging table.

This step assumes that you have the mapping open in the Diagram tab. If you used the Auto Mapping process, the columns with the same names are connected directly.

In the

Diagram

workspace, review the connections that were created automatically. If any of the automatic connections are incorrect, delete the connections.

Click the connector line.

Right-click and select

Delete Link

Decide if any of the unconnected columns in the landing table must be connected to columns in the staging table.

When planning a connection, consider the following requirements:

Data types. The columns must have either the same data type or a data type that can be implicitly converted.

Cleansing. Do you want to cleanse the data or transform the data before loading it into the staging table? If so, you need to decide which function you want to use.

String length. In the staging table, columns with the CHAR or VARCHAR data types must have a length that is equal to or greater than the length for the column in the landing table.

At load time, if a string is too long for the column in the staging table, the load process sends the entire record to the reject table.

If data does not require cleansing, connect the columns directly. To connect the columns, from the landing table column, drag the output connector to the input connector on staging table column.

If data requires cleansing, add a function to the workspace and then connect the columns.

In the workspace, right-click and select

Add Function

Select the function and click

The function appears in the Diagram workspace.

Find the column in the landing table. Drag its output connector to the input connector on the function. Repeat to add additional columns as inputs to the function.

From the function, drag its output connector to the input connector of the column in the staging table.

After you finish adding connections, click

Save

Map Columns Between a Landing Table and Staging Tables

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal