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.
- Expand the Tutorial folder in the Directory Explorer, right-click Column
Maps and click . The New Column Map wizard opens.
- On the Enter Column Map name page, enter SAMPLE.CMAP in
the Name field. Click Next.
- On the Select a Source Table page, do the following steps:
- In the Selection method area, click Data
store alias.
- 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.
- Click Display Tables. The table list displays tables that match the pattern.
- Select the OPTIM_CUSTOMERS table.
- Click Next.
- On the Select a Target Table page, do the following steps:
- 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.
- Click Display Tables. The table list displays tables that match the pattern.
- Select the OPTIM_CUSTOMERS table.
- Click Finish.
The new column map is displayed in the Column Map Editor.