Creating a column map

In this exercise, you will create a column map. A column map provides specifications needed to match or exclude columns from processing in a data management service. Convert, insert, and load services must reference a table map, which may reference one or more column maps. You can use a column map to define data transformations with functions or column map procedures.

To create a column map:

  1. Expand the Tutorial folder in the Directory Explorer, right-click Column Maps and click New Column Map. The New Column Map wizard opens.
  2. On the Enter Column Map name page, enter SAMPLE.CMAP in the Name field. Click Next.
  3. On the Select a Source Table page, do the following steps:
    1. In the Selection method area, click Data store alias.
    2. In the Data store alias area, enter the following search pattern in the Table Search Pattern field, : DATA_STORE_ALIAS.SCHEMA.OPTIM_CUSTOMERS, where DATA_STORE_ALIAS.SCHEMA are the data store alias and schema that contain the Optim™ sample data. For example: OPTIM.SAMPLE.OPTIM_CUSTOMERS.
    3. Click Display Tables. The table list displays tables that match the pattern.
    4. Select the OPTIM_CUSTOMERS table.
    5. Click Next.
  4. On the Select a Target Table page, do the following steps:
    1. In the Table Search Pattern field, enter the following search pattern: SCHEMA.OPTIM_CUSTOMERS, where SCHEMA is the schema that contains the Optim sample data. For example: SAMPLE.OPTIM_CUSTOMERS.
    2. Click Display Tables. The table list displays tables that match the pattern.
    3. Select the OPTIM_CUSTOMERS table.
  5. Click Finish.

The new column map is displayed in the Column Map Editor.



Feedback