You can import the following target definitions:
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:
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:
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:
For example, if Vendor A provided a driver named vendoraodbc.dll, enter the following under the ODBCDLL heading:
Importing Relational Target Definitions
To create a relational target definition, use the Target Designer to import target metadata.
To import a relational target definition:
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.
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.
The selected target definitions now appear in the Navigator under the Targets icon.
All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.