Bulk Data Movement Guide

10.5
- 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

Moving Sequential File Bulk Data

Use the following procedure to perform a bulk data movement operation for a sequential file data source. This procedure assumes that you use PWXPC to integrate PowerExchange with PowerCenter.

In the PowerExchange Navigator, create a data map for the source sequential file.

Import a local or remote COBOL or PL/I copybook, if available, to define the layout of all or selected sequential records.

Open the data map in the Resource Explorer, and click the nonrelational record view or the relational table view to verify that the metadata was successfully retrieved.

To send the data map to the PowerExchange Listener on the remote system, select the data map in the Resource Explorer and click File
>
Send to Remote Node
.

In the Location
field, enter the node name of the remote node that is specified in a NODE statement in the dbmover.cfg file on the local PowerExchange system. Complete the other fields, as needed.

If you do not complete this step, you are prompted to send the data map to the remote node when you run a database row test.

Run a database row test on the table view of the metadata to verify that actual data can be returned from the sequential file source.

If you need to change the data map to get the data you want, re-run the database row test on the revised data map.

In the PowerCenter Designer, import the PowerExchange data map and create a mapping.

When you import the data map, in the Location
field, enter the node name of the remote node that is specified in a NODE statement in the dbmover.cfg file on the local PowerExchange system. Also, in the Source Type
field, select

SEQ

In the PowerCenter Workflow Manager, define a workflow and session and configure a PWX NRDB Batch application connection. Then start the workflow to perform bulk data movement.

If you are writing to a sequential target file using a PowerExchange connection and you want PowerExchange to create the empty target file 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.

Sequential File Bulk Data Movement

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal