Mapping Between Source and Target Tables
Perform this procedure to create mapping between source and target tables.
-
In Informatica PowerCenter Designer, select the folder in the repository where you want to create your Vertica mapping.
- Click the Mapping Designer icon.
- From the Mappings list box, select Create.
- Enter a mapping name and click OK.
-
Choose the source, datatypes_src, and drag it to the Mapping Designer window. An Application Source Qualifier also appears; your source is mapped to Informatica. (This example sets up a basic workflow and is not meant to be a realistic sample. Note also that this example shows that configuration changes would be required where both source and/or target are in Vertica databases.)
- Drag your target, datatypes_tgt, to the Mapping Designer window.
-
From the Layout list box, select Autolink by Name.
-
Confirm the from and to transformations, and click OK.
- Save your work. Next, follow the procedure in, you create a workflow that uses your mapping. Follow the procedure in, Creating a Workflow.