Importing a Target Definition - Informatica

You can import the following target definitions:

  • Flat file. The Target Designer uses the Flat File Wizard to import a target definition from a flat file that matches the structure of the flat file.
  • Relational table. You can import a relational table to create a target definition that matches the structure of the relational table.
  • XML file. You can import an XML target definition from an XML, DTD, or XML schema file.

To import a relational target definition, you need to configure connectivity between the target database and the PowerCenter Client.

Use a target definition in a mapping after you have added it to the repository.

Relational Target Definitions

When you import a target definition from a relational table, the Designer imports the following target details:

  • Target name. The name of the target.
  • Database location. You specify the database location when you import a relational source. You can specify a different location when you edit the target definition in the Target Designer and when you configure a session.
  • Column names. The names of the columns.
  • Datatypes. The Designer imports the native datatype for each column.
  • Key constraints. The constraints in the target definition can be critical, since they may prevent you from moving data into the target if the Integration Service violates a constraint during a workflow. For example, if a column contains the NOT NULL constraint and you do not map data to this column, the Integration Service cannot insert new records into the target table.
  • Key relationships. You can customize the Target Designer to create primary key- foreign key relationships.
  • Click Tools > Options and select the Format tab. Select Import Primary and Foreign Keys.

    You can also create logical relationships in the repository. Key relationships do not have to exist in the database.

When you import target definitions, the Designer does not import the target indexes. You can change this default setting in powrmart.ini. You can find powrmart.ini in the root directory of the PowerCenter Client installation.

To import target definition indexes, add the following text to powrmart.ini [Main] section:

Note:Because views can include columns from more than one table, the Integration Service might encounter database errors when trying to insert, update, or delete data. If you import a target view, make sure that it is a view of a single table.

Connectivity for Relational Targets

To import a relational target definition, you must be able to connect to the database from the client machine using a properly configured ODBC data source or gateway. You may also require read permission on the database object.

When you create an ODBC data source, you must also specify the driver that the ODBC driver manager sends database calls to. The following table shows the recommended ODBC drivers to use with each database:

Connectivity for Relational Targets

When you use a third-party ODBC data source to import a target definition, the Designer displays a message indicating that the third-party driver is not listed in powermart.ini. The Designer attempts to import target definition metadata using a driver that is shipped with PowerCenter. If the third-party provides a driver to import metadata, configurev powrmart.ini.

Configuring a Third-Party ODBC Data Source

To import a target definition with an ODBC driver that is not included in the powrmart.ini, configure the powrmart.ini.

To configure powrmart.ini for a third-party ODBC data source:

  1. Copy the driver to the following directory:
  2. <PowerCenter Installation Directory>clientin
  3. Locate and open powrmart.ini in the following directory:
  4. <PowerCenter Installation Directory>clientin
  5. Add an entry into the file under the ODBCDLL section that includes the name of the ODBC data source and the driver.
  6. For example, if Vendor A provided a driver named vendoraodbc.dll, enter the following under the ODBCDLL heading:
    Vendor A=vendoraodbc.dll

  7. Save and close powrmart.ini.
  8. Restart the PowerCenter Client and import the target definition.

Importing Relational Target Definitions

To create a relational target definition, use the Target Designer to import target metadata.

To import a relational target definition:

  1. In the Target Designer, click Targets > Import from Database.
  2. Select the ODBC data source used to connect to the target database.
  3. If you need to create or modify an ODBC data source first, click the Browse button to open the ODBC Administrator. After creating or modifying the ODBC source, continue with the following steps.

  4. Enter the user name and password needed to open a connection to the database, and click Connect.
  5. If you are not the owner of the table you want to use as a target, specify the owner name.
  6. Drill down through the list of database objects to view the available tables as targets.
  7. Select the relational table or tables to import the definitions into the repository.
  8. You can hold down the Shift key to select a block of tables, or hold down the Ctrl key to make non-contiguous selections. You can also use the Select All and Select None buttons to select or clear all available targets.

  9. Click OK.
  10. The selected target definitions now appear in the Navigator under the Targets icon.

All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd Protection Status

Informatica Topics