PeopleSoft 9.1 PeopleBook: Data Transformer

Creating Maps

This chapter discusses how to create map definitions.

Creating Map Definitions

This section discusses how to:

Define map information.
Define map field details.
Perform map edits.
Preview map results.
Update map processing options.

Pages Used to Create Map Definitions

Page Name	Definition Name	Navigation	Usage
Map Information	EOEW_MAP_DFN	Enterprise Components, Data Transformation, Define Maps, Map Information	Enter general mapping information.
Map Field Detail	EOEW_MAP_FLD	Enterprise Components, Data Transformation, Define Maps, Map Information, Map Field Detail	Enter field-level mapping details.
Map Edits	EOEW_MAP_EDIT	Enterprise Components, Data Transformation, Define Maps, Map Information, Map Edits	Edit map source input values that are used in transformations.
Preview Map Results	EOEW_TARPREVIEW	Enterprise Components, Data Transformation, Define Maps, Map Information, Preview Map Results	View a subset of your data based on the defined map.
Map Options	EOEW_MAP_OPT	Enterprise Components, Data Transformation, Define Maps, Map Information, Map Options	Override or select options at the map level.
Map Definition - Comments	EOEW_MAP_COMMENT	Enterprise Components, Data Transformation, Define Maps, Map Information, Comments	Enter comments that are related to the map definition.

Defining Map Information

Access the Map Information page (Enterprise Components, Data Transformation, Define Maps, Map Information).

Subject Area

Select a subject area.

For new maps, the subject area will be set to the default as defined on the Subject Area page.

Source

Enter the source data object for this map.

Note. The source data object prompt is restricted by subject area. You see only those objects that are in the map definition's current subject area and those in the default subject area.

Add Source Data Object

Click to navigate to the Source Data Object component and create a new source data object to use as the source.

Update Source Data Object

Click to navigate to the Source Data Object component and change the source data object that you selected as the source.

Target

Select the target data object.

This value controls the target fields that are available on the Map Field Details page.

Error Handling

No error handling needed: Select to have the system perform no data validation and insert all rows into the target table.

Identify error row: Select to have the system perform data validation and insert both valid and invalid rows into the target table. You must select a target field to contain the error flag on the Map Field Detail page.

Note. The error flag will not be available for any other type of mapping.

Correct data error & reprocess: Select to have the system perform data validation, insert valid rows into the target table, and insert invalid rows into a user-defined error table. You will be prompted to create an error record on the Map Field Detail page.

Note. The system administrator must build the user-defined error table in PeopleSoft Application Designer before you load the defined map.

The create error record push button will create a record in PeopleSoft metadata that has all of the necessary columns needed at runtime. It must then be build using Application Designer. If your map changes (different transformations, translation sets, and so on), you will need to recreate the error table because it must match exactly.

See Also

Defining Subject Areas

Understanding Extracting, Transforming, and Loading Source Data

Defining Map Field Details

Access the Map Field Detail page (Enterprise Components, Data Transformation, Define Maps, Map Information, Map Field Detail).

Source Input Type

Blank: If this field is left blank, the description field will default to a blank, zero, or the appropriate PeopleSoft null value. This null value will be inserted to the target field.

Source: Select if the value is from the source file. You are prompted to select a source prompt field from the source data object.

Constant: Select if the value is a constant value, and then enter that value. If a constant needs to be applied to more than one map, a default target field should be created.

Default: Select to use a default value, and then select a source prompt to select the appropriate target field default. Click the Default link to access the Set Target Field Default page to see the actual prompt value.

Transformation: Select to use a transformation, and then select a source prompt to select the appropriate transformation. Click the Transform link to view transformation definitions, or click the Add link to add a new definition by using the Transformation Wizard.

Translation Set: Select to use a translation set, and then select a source prompt to select the appropriate source data object field. Select a description which will be the appropriate translation set to apply to the source field. Click the Translation link to view translation set values, or click the Add link to add a new set.

Source Prompt

Select a source prompt based on your source input type. The prompt will change based on the source input type. Be aware of the mapping that you are setting up.

Note. Translation set and transformation source prompts are restricted by subject area and transformation type. Only objects that are in the map definition's current subject area and those in the default subject area appear on the page. Only Look Up and PeopleCode type transformations appear.

Description

The description will change based on the source input type and source prompt selected. Be aware of the mapping that you are setting up.

Enter a description if you selected Constant as the input type. The description is the value that you want mapped to the target field.

Enter a translation set if you selected Translation Set as the input type.

Target Field

Lists the name of all of the fields in your target file.

Detail

Displays the Transform, Default, or Translation link, based on the selected input type. This link transfers to the definition page of the selected item.

Add

Appears if the selected input type is Transformation or Translation Set. This link transfers to the definition page of the selected item in Add mode.

Save Map As

Click to save an existing map definition under a new map name.

Use this function to create a new map definition that will only slightly differ from the original map. Once saved, you can make the necessary changes to the new map. The new map is maintained separately.

Apply AutoMapper

Click to initially define map field details.

AutoMapper automatically attempts to match the source to the target field list. It also applies any required map rules, including target field defaults, translation set values, and transformations. AutoMapper then maps remaining target fields with constant values from the PSRECFIELD.DBFIELDNAME.SQL assembler and coordinates the transformation steps.

If you must modify the mapping that is defined by AutoMapper, you can make these changes using the fields on this page.

Warning! Rerunning the AutoMapper overrides any mappings that you have already done. Use caution before doing this-it is as if you are starting over with an Add function.

Synchronize fields

Click to realign the source and target fields on the map with any changes that may have occurred since its origination.

You can add new fields to the target with PeopleSoft Application designer once a map has been saved. Using Synchronize fields will insert these new fields in the map field detail grid. Additional synchronization is done on source fields (based on the current source data object definition) and prompts. Selecting this button will not override previously saved mappings.

Show/Hide Fields Details

Click to expand the grid to include field format and length information for both source and target fields. Click again to avoid the horizontal scroll.

See Also

Preparing to Create Maps

Performing Map Edits

Access the Map Edits page (Enterprise Components, Data Transformation, Define Maps, Map Information, Map Edits).

Source Input Value

Select an Edit transformation.

Note. The source input value prompt is restricted by subject area and transformation type. You see only those objects that are in the map definition's current subject area and those in the default subject area. You also see only edit transformations.

Detail

Click to access the Transformation Definition page and edit transformation definition information.

Add

Click to access the Transformation Definition page and add a new transformation.

Previewing Map Results

Access the Preview Map Results page (Enterprise Components, Data Transformation, Define Maps, Map Information, Preview Map Results).

Click the Preview button to view a subset of the results based on your map definition.

Use this feature to check the validity of the map. By previewing what the results of running the map would be against a small set of data, you can determine if your mappings are defined correctly.

Note. Attempting to preview complex maps can quickly consume processing and memory resources on your application server.

The preview maximum row count is set using the Data Transformer Installation Options page. Large row counts take more time and resources to preview. Consider setting your preview row count relatively low.

See Also

Defining Installation Options

Updating Map Processing Options

Access the Map Options page (Enterprise Components, Data Transformation, Define Maps, Map Information, Map Options).

Note. Only system administrators may access this page.

Duplicate Row Handling	Copy Duplicates to Error Table: Select to have the system copy all duplicate rows to the error table. Copy first row to Target: Select so that if the system finds a duplicate row in the error table, it inserts only the first row of the duplicates into the target. Copy last row to Target: Select so that if the system finds a duplicate row in the error table, the system inserts only the last row of the duplicates into the target. Reject all duplicate rows: Select to have the system reject all duplicate rows and not log them in the error table. Note. Values are based on the error handling that is specified on the Map Information page. If you don't see all of the preceding values, adjust the error handling option.
(Optional) Create Temporary Table	Select if you want to override the Data Transformer installation options and Subject Area selections for this map to create a temporary table at runtime. This is needed only when an implementation allows or disallows the dynamic temporary table creation per subject area. This temporary table is only needed by the engine and will be deleted at engine completion. It is not available in PeopleSoft metadata. Note. If you do not select this check box, you will be required to specify a temporary table record name on the map for use at runtime. This record will be available in PeopleSoft metadata and live permanently after the engine execution. Determining which of these options to used needs to be carefully considered. A dynamic temporary table will automatically change when the map changes, a non-dynamic temporary table requires maintenance.
Override Tablespace Name From Subject Area Default	Select to override the Data Transformer installation options and Subject Area options for specific maps. This is only necessary if the implementation chooses to spread the temporary tables that are generated at runtime over multiple tablespaces.
Select Date/Time Field Name To Be Used For Incremental Load Processing	Only datetime field types appear in the prompt. This field is used at run time to determine the next segment of data to incrementally load.

See Also

Defining Installation Options

Defining Subject Areas

Entering Map Definition Comments

Access the Map Definition - Comments page (Enterprise Components, Data Transformation, Define Maps, Map Information, Comments).

Use the Comments field to provide details about the purpose of the map definition.

Subject Area	Select a subject area. For new maps, the subject area will be set to the default as defined on the Subject Area page.
Source	Enter the source data object for this map. Note. The source data object prompt is restricted by subject area. You see only those objects that are in the map definition's current subject area and those in the default subject area.
Add Source Data Object	Click to navigate to the Source Data Object component and create a new source data object to use as the source.
Update Source Data Object	Click to navigate to the Source Data Object component and change the source data object that you selected as the source.
Target	Select the target data object. This value controls the target fields that are available on the Map Field Details page.
Error Handling	No error handling needed: Select to have the system perform no data validation and insert all rows into the target table. Identify error row: Select to have the system perform data validation and insert both valid and invalid rows into the target table. You must select a target field to contain the error flag on the Map Field Detail page. Note. The error flag will not be available for any other type of mapping. Correct data error & reprocess: Select to have the system perform data validation, insert valid rows into the target table, and insert invalid rows into a user-defined error table. You will be prompted to create an error record on the Map Field Detail page. Note. The system administrator must build the user-defined error table in PeopleSoft Application Designer before you load the defined map. The create error record push button will create a record in PeopleSoft metadata that has all of the necessary columns needed at runtime. It must then be build using Application Designer. If your map changes (different transformations, translation sets, and so on), you will need to recreate the error table because it must match exactly.

Source Input Type	Blank: If this field is left blank, the description field will default to a blank, zero, or the appropriate PeopleSoft null value. This null value will be inserted to the target field. Source: Select if the value is from the source file. You are prompted to select a source prompt field from the source data object. Constant: Select if the value is a constant value, and then enter that value. If a constant needs to be applied to more than one map, a default target field should be created. Default: Select to use a default value, and then select a source prompt to select the appropriate target field default. Click the Default link to access the Set Target Field Default page to see the actual prompt value. Transformation: Select to use a transformation, and then select a source prompt to select the appropriate transformation. Click the Transform link to view transformation definitions, or click the Add link to add a new definition by using the Transformation Wizard. Translation Set: Select to use a translation set, and then select a source prompt to select the appropriate source data object field. Select a description which will be the appropriate translation set to apply to the source field. Click the Translation link to view translation set values, or click the Add link to add a new set.
Source Prompt	Select a source prompt based on your source input type. The prompt will change based on the source input type. Be aware of the mapping that you are setting up. Note. Translation set and transformation source prompts are restricted by subject area and transformation type. Only objects that are in the map definition's current subject area and those in the default subject area appear on the page. Only Look Up and PeopleCode type transformations appear.
Description	The description will change based on the source input type and source prompt selected. Be aware of the mapping that you are setting up. Enter a description if you selected Constant as the input type. The description is the value that you want mapped to the target field. Enter a translation set if you selected Translation Set as the input type.
Target Field	Lists the name of all of the fields in your target file.
Detail	Displays the Transform, Default, or Translation link, based on the selected input type. This link transfers to the definition page of the selected item.
Add	Appears if the selected input type is Transformation or Translation Set. This link transfers to the definition page of the selected item in Add mode.
Save Map As	Click to save an existing map definition under a new map name. Use this function to create a new map definition that will only slightly differ from the original map. Once saved, you can make the necessary changes to the new map. The new map is maintained separately.
Apply AutoMapper	Click to initially define map field details. AutoMapper automatically attempts to match the source to the target field list. It also applies any required map rules, including target field defaults, translation set values, and transformations. AutoMapper then maps remaining target fields with constant values from the PSRECFIELD.DBFIELDNAME.SQL assembler and coordinates the transformation steps. If you must modify the mapping that is defined by AutoMapper, you can make these changes using the fields on this page. Warning! Rerunning the AutoMapper overrides any mappings that you have already done. Use caution before doing this-it is as if you are starting over with an Add function.
Synchronize fields	Click to realign the source and target fields on the map with any changes that may have occurred since its origination. You can add new fields to the target with PeopleSoft Application designer once a map has been saved. Using Synchronize fields will insert these new fields in the map field detail grid. Additional synchronization is done on source fields (based on the current source data object definition) and prompts. Selecting this button will not override previously saved mappings.
Show/Hide Fields Details	Click to expand the grid to include field format and length information for both source and target fields. Click again to avoid the horizontal scroll.