Informatica Mappings
This section describes new Informatica mapping features in version 10.2.1.
Dynamic Mappings
This section describes new dynamic mapping features in version 10.2.1.
Input Rules
Effective in version 10.2.1, you can perform the following tasks when you create an input rule:
- •Create an input rule by complex data type definition.
- •Restore source port names when you rename generated ports.
- •Select ports by source name when you create an input rule by column name or a pattern.
- •View source names and complex data type definitions in the port preview.
For more information, see the "Dynamic Mappings" chapter in the Informatica 10.2.1 Developer Mapping Guide.
Port Selectors
Effective in version 10.2.1, you can configure a port selector to select ports by complex data type definition.
For more information, see the "Dynamic Mappings" chapter in the Informatica 10.2.1 Developer Mapping Guide.
Validate Dynamic Sources and Targets
Effective in version 10.2.1, you can validate dynamic sources and targets. To validate dynamic sources and targets, resolve the mapping parameters to view a run-time instance of the mapping. Validate the run-time instance of the mapping.
For more information, see the "Dynamic Mappings" chapter in the Informatica 10.2.1 Developer Mapping Guide.
Mapping Parameters
This section describes new mapping parameters features in version 10.2.1
Assign Parameters
Effective in version 10.2.1, you can assign parameters to the following mapping objects and object fields:
Object | Field |
|---|
Customized data object read operation | Custom query Filter condition Join condition PreSQL PostSQL |
Customized data object write operation | PreSQL PostSQL Update override |
Flat file data object | Compression codec Compression format |
Lookup transformation | Custom query. Relational only. |
Read transformation | Custom query. Relational only. Filter condition. Relational only. Join condition. Relational only. PreSQL. Relational only. PostSQL. Relational only. |
Write transformation | PreSQL. Relational only. PostSQL. Relational only. Update override. Relational only. |
For more information, see the "Mapping Parameters" chapter in the Informatica 10.2.1 Developer Mapping Guide.
Resolve Mapping Parameters
Effective in version 10.2.1, you can resolve mapping parameters in the Developer tool. When you resolve mapping parameters, the Developer tool generates a run-time instance of the mapping that shows how the Data Integration Service resolves the parameters at run time. You can run the instance of the mapping where the parameters are resolved to run the mapping with the selected parameters.
The following table describes the options that you can use to resolve mapping parameters:
Mapping Parameters | Description |
|---|
Apply the default values in the mapping | Resolves the mapping parameters based on the default values configured for the parameters in the mapping. If parameters are not configured for the mapping, no parameters are resolved in the mapping. |
Apply a parameter set | Resolves the mapping parameters based on the parameter values defined in the specified parameter set. |
Apply a parameter file | Resolves the mapping parameters based on the parameter values defined in the specified parameter file. |
To quickly resolve mapping parameters based on a parameter set. Drag the parameter set from the Object Explorer view to the mapping editor to view the resolved parameters in the run-time instance of the mapping.
For more information, see the "Mapping Parameters" chapter in the Informatica 10.2.1 Developer Mapping Guide.
Validate Mapping Parameters
Effective in version 10.2.1, you can validate mapping parameters in the Developer tool. To validate mapping parameters, first resolve the mapping parameters. When you resolve mapping parameters, the Developer tool generates a run-time instance of the mapping that shows the resolved parameters. Validate the run-time instance of the mapping to validate the mapping parameters.
For more information, see the "Mapping Parameters" chapter in the Informatica 10.2.1 Developer Mapping Guide.
Running Mappings
This section describes new run mapping features in version 10.2.1.
Run a Mapping from the Object Explorer View
Effective in version 10.2.1, you can run a mapping from the Object Explorer view. You do not have to open the mapping in the mapping editor. Right-click the mapping in the Object Explorer view and click Run.
For more information, see the Informatica 10.2.1 Developer Tool Guide.
Run a Mapping Using Advanced Options
Effective in version 10.2.1, you can run a mapping in the Developer tool using advanced options. In the advanced options, you can specify a mapping configuration and mapping parameters. Specify the mapping configuration and mapping parameters each time that you run the mapping.
The following table describes the options that you can use to specify a mapping configuration:
Option | Description |
|---|
Select a mapping configuration | Select a mapping configuration from the drop-down menu. To create a new mapping configuration, select New Configuration. |
Specify a custom mapping configuration | Create a custom mapping configuration that persists for the current mapping run. |
The following table describes the options that you can use to specify mapping parameters:
Mapping Parameters | Description |
|---|
Apply the default values in the mapping | Resolves the mapping parameters based on the default values configured for the parameters in the mapping. If parameters are not configured for the mapping, no parameters are resolved in the mapping. |
Apply a parameter set | Resolves the mapping parameters based on the parameter values defined in the specified parameter set. |
Apply a parameter file | Resolves the mapping parameters based on the parameter values defined in the specified parameter file. |
For more information, see the Informatica 10.2.1 Developer Mapping Guide.
Truncate Partitioned Hive Target Tables
Effective in version 10.2.1, you can truncate an external or managed Hive table with or without partitions.
Previously, you could design a mapping to truncate a Hive target table, but not an external, partitioned Hive target table.
For more information on truncating Hive targets, see the "Mapping Targets in the Hadoop Environment" chapter in the Informatica Big Data Management 10.2.1 User Guide.