Bulk Data Movement Guide

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

Back Next

Performing a Multiple-Record Write to an IMS Unload Data Set

To transfer data in the correct physical sequence from a multiple-record IMS unload data set source to a multiple-record IMS unload data set target, configure a session that performs multiple-record writes.

Create a multiple-record data map for the IMS data source, if you have not already created one.

In the PowerCenter Designer, click Sources > Import from PowerExchange
.

In the

Import from PowerExchange

dialog box, enter the required information.

The following table describes the required information:

Attribute	Description
Location	Name of the node on which the source file resides. This value must match the name of a NODE statement in the PowerExchange dbmover.cfg file.
User Name	User name that has the database authority to connect to the target.
Password	Password that is associated with the user name.
Multi-Record Datamaps	Whether to list multiple-record data maps for selection. Select this check box.
Use Sequence Fields	Whether to generate sequence fields for multiple-record write operations. Select this check box.
Source Type	Data source type. Select IMS.

For more information about this dialog box, see

PowerExchange Interfaces for PowerCenter

Click

Connect.

The available multiple-record data maps appear in the

Selected Datamaps

box.

Select the data map that you want to import.

Click

OK.

The source definition appears in the workspace.

Click Targets > Import from PowerExchange
.

In the

Import from PowerExchange

dialog box, enter the required information.

The following table describes the required information:

Attribute	Description
Location	Name of the node on which the source file resides. This value must match the name of a NODE statement in the PowerExchange dbmover.cfg file.
User Name	User name that has the database authority to connect to the source.
Password	Password that is associated with the user name.
Multi-Record Datamaps	Whether to list multiple-record data maps for selection. Select this check box.
Use Sequence Fields	Whether to generate sequence fields for multiple-record write operations. Select this check box.
Source Type	Data target type. Select IMS.

Click

Connect.

The available multiple-record data maps appear in the

Selected Datamaps

box.

Select the same data map that you selected for the source definition.

Click

OK.

The target definition appears in the workspace.

Create a mapping that includes the source definition, Source Qualifier transformation, and target definition.

Between the Source Qualifier transformation and the target definition, you can include transformations that meet the requirements in Rules and Guidelines for Multiple-Record Writes to IMS Unload Files.

Define a connection for the IMS database, if one does not already exist.

Define PowerCenter session properties:

In the Task Developer, double-click the session to edit it.

On the

Mapping

tab, click the

Sources

view.

Under

Properties

, set the

IMS Unload File Name

property to the name of the IMS source unload file.

Define additional source properties as needed.

On the

Mapping

tab, click the

Targets

view.

Under

Properties

, set the

IMS Unload File Name

property to the name of the IMS unload file that you want the session to allocate.

Define additional target properties as needed.

If you want PowerExchange to create the empty target data set before the PowerCenter session runs, include the CREATEFILE command in the

Pre SQL

session property for the target. For more information, see the discussion of empty files in the appendix, "PowerExchange Interfaces for PowerCenter Tips," in the

PowerExchange Interfaces for PowerCenter

guide.

Click OK
.

Multiple-Record Writes to IMS Unload Data Sets

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal