To create, edit, and test a data map, perform the following high-level tasks:
If PowerExchange is not installed on the local machine, where you will run the createdatamaps command, copy the copybooks and DBDs to the local machine.
If you configure the control file to find record ID fields, the copybooks must reside on the source z/OS system, and PowerExchange must be installed on the machine on which you run the createdatamaps command.
Create the control file.
You can create a new file using an XML editor. Or you can open a sample control file in an XML editor, rename the file, and edit the file as needed.
Run the infacmd pwx createdatamaps command from the command line on any machine that can access the Informatica domain.
Review the output log. If errors occur, correct them and run the command again.
Copy the data map to the PowerExchange Navigator machine.
Open the data map in the PowerExchange Navigator.
If the PowerExchange Navigator is already open when you copy the data map, select
File
Refresh
to refresh the list of data maps.
If required, edit the data map.
For example, you might need to delete unused records, assign record ID values, or assign other properties that you cannot assign with the createdatamaps utility.
If you configured the control file to find record ID fields, review the record types that the utility created and the record ID values that the utility assigned. Edit these results if necessary.
Perform a database row test.
Make additional edits and perform additional database row tests, as needed.