Importing a Target Database Table
The following example shows how to import a target table from a Vertica database.
-
In Informatica PowerCenter Designer, select the folder in the repository where you want to create your Vertica target.
- Click the Target Designer icon.
-
From the Targets list box, choose Import from Database.
-
From the Import Tables dialog box, choose the name of your ODBC data source, and enter Username and Password.
-
Click Connect. Under Select tables, choose the schema public.
-
Choose a table and Click OK. For this example, choose only the table, datatypes_tgt.
The table appears in the Target Designer panel.
-
Change the table's database type to VERTICA. Double-click the name of the table to launch the Edit Tables dialog box.
- From the Table tab, Database type list box, choose VERTICA.
- Click OK. You have imported a target table. Next, follow the procedure in, Mapping Between Source and Target Tables.
Note: As of Informatica Version 9.6.1 Hot Fix 2 and later, if you want to use the version of Vertica you downloaded and installed, select the Vertica option from the dropdown menu. If you intend to use the new Vertica Connector from Informatica, select VERTICA from the dropdown menu.