PowerExchange Interfaces for PowerCenter

10.4.1
- 10.5.8
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.0 HotFix 1
- 10.4.0

Back Next

Importing Nonrelational Source Definitions

You can connect to PowerExchange locally or to a PowerExchange Listener to import a nonrelational data maps to create source definitions or a data mapped DB2 definition.

When you connect to PowerExchange, the Designer displays data map schemas and tables for the source type specified. Before you connect to PowerExchange, you can filter this information based on a schema name, data map name, or both. Then select a data map to create the source definition.

The following procedure imports single- and multi-record data maps to create source definitions. You can import multiple-record data maps for IMS unload data sets, VSAM data sets, and sequential files. For multiple-record data maps, select the

Multi-Record Datamaps

attribute.

Click

Sources

Import from PowerExchange

In the

Import from PowerExchange

dialog box, enter information for importing a nonrelational data map.

The following table describes the required and optional attributes:

Attribute	Required or Optional	Description
Location	Required	Name of the node where the PowerExchange Listener runs, as specified in a NODE statement in the PowerExchange DBMOVER configuration file that is on the system where the database resides.
User Name	Required	A user name that has the authority to connect to the database. For sources on supported Linux, UNIX, or Windows systems, if you have enabled PowerExchange LDAP user authentication, the user name is the enterprise user name. For more information, see the PowerExchange Reference Manual .
Password	Required	A password for the specified user. Passwords that are less than nine characters in length are not validated. To avoid errors that might arise due to code page differences, Informatica recommends that the password includes only those characters that are allowed for passphrases. For nonrelational sources on z/OS, and for sequential source files on i5/OS for bulk data movement, you can enter a valid PowerExchange passphrase instead of a password. An i5/OS passphrase can be from 9 to 31 characters in length. A z/OS passphrase can be from 9 to 128 characters in length. A passphrase can contain the following characters: Uppercase and lowercase letters The numbers 0 to 9 Spaces The following special characters: ’ - ; # \ , . / ! % & * ( ) _ + { } : @ \| < > ? The first character is an apostrophe. Passphrases cannot include single quotation marks (‘), double quotation marks (“), or currency symbols. On z/OS, the allowable characters in the IBM IRRPHREX exit do not affect the allowable characters in PowerExchange passphrases. On z/OS, valid RACF passphrase can be up to 100 characters in length. PWXPC truncates passphrases longer than 100 characters when passing them to RACF for validation. To use passphrases, ensure that the PowerExchange Listener runs with a security setting of SECURITY=(1,N) or higher in the DBMOVER member. For more information, see "SECURITY Statement" in the PowerExchange Reference Manual .
Multi-Record Datamaps	Optional	Select this option to list multiple-record data maps, which are available for IMS, SEQ, and VSAM sources only. For more information, see Group Source Processing in Bulk Data Movement Sessions with Nonrelational Data Sources. When you try to import a very large multiple-record data map for a nonrelational data source into PowerCenter Designer, the import might fail. In this case, instead of creating a multiple-record data map, create a separate data map for each source record.
Use Sequence Fields	Optional	Select this option to generate sequence fields. IMS unload sources only. You can select this option only if you also select Multi-Record Data Maps . For more information, see Multi-Record Writes to Nonrelational Targets.
Source Type	Required	Select one of the following source types: ADABAS, DATACOM, DB2MAP, DB2UNLD, IDMS, IMS, SEQ, or VSAM.
CDC Datamaps	-	Select this option to list CDC extraction maps - source only.
Network Timeout	Optional	The number of seconds that elapse during a network send or receive operation before PowerExchange ends the connection and issues a timeout error message.
Schema	Optional	A schema name to use for filtering the data maps.
Map name	Optional	A data map name to use for filtering the data maps.
Respect Case	Optional	Select this option to have PowerExchange use case-sensitive filtering of the data maps based on the values in the Schema and Map name fields. When this option is not selected, PowerExchange ignores case when searching for data maps.
Selected Datamaps	-	Lists the available data maps for the connection, source type, and filter details that you entered.

Optionally, define a filter to narrow the list of schemas and tables.

To define a filter condition, enter a schema name, a table name, or both. You can enter name patterns by using the following wildcard characters:

*
(asterisk). Represents one or more characters.

?
(question mark). Represents one character.

For example:

A* displays schemas and tables that begin with an A.

*A displays schemas and tables that end with an A.

*cust* displays schemas that contain “cust.”

Click

Connect

The Designer displays the metatdata for the data maps in the

Selected Datamaps

box. If no data maps are found, the Designer displays “No Data Found."

Select the data map or data maps that you want to import.

To make multiple selections, use the Shift key or Ctrl key or click

Select all

Click OK
.

The source definitions are displayed. The Designer uses the data map names as the names of the source definition.

If you select more than one source object in the

Import from PowerExchange

dialog box and do not select

Multi-Record Datamaps

, the resulting target objects might have no columns.

To avoid this problem, select

Respect Case

in the

Import from PowerExchange

dialog box.

Working with Nonrelational Source and Target Definitions

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

PowerExchange Interfaces for PowerCenter

PowerExchange Interfaces for PowerCenter

Importing Nonrelational Source Definitions

Importing Nonrelational Source Definitions