Mapping Between Source and Target Tables

Perform this procedure to create mapping between source and target tables.

  1. In Informatica PowerCenter Designer, select the folder in the repository where you want to create your Vertica mapping.

  2. Click the Mapping Designer icon.
  3. From the Mappings list box, select Create.
  4. Enter a mapping name and click OK.
  5. 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.)

  6. Drag your target, datatypes_tgt, to the Mapping Designer window.
  7. From the Layout list box, select Autolink by Name.

  8. Confirm the from and to transformations, and click OK.

  9. Save your work. Next, follow the procedure in, you create a workflow that uses your mapping. Follow the procedure in, Creating a Workflow.