Mapping Specification Types
You can create different types of mapping specifications based on the business logic you want to develop.
You can create the following types of mapping specifications:
- Mapping specification with no target
- You can create a mapping specification with a source or multiple sources and no target during the initial phase of mapping specification development. The mapping specification is not valid and you cannot preview it or load the results of the mapping specification to the target. However, you can edit the mapping specification to configure the target and validate it.
- Mapping specification with multiple sources
- You can create a mapping specification with two or more sources and a target. When you use multiple sources you must specify a join condition for the sources.
- Mapping specification with another mapping specification as a source
- You can create a mapping specification that uses another mapping specification as a source. During incremental development of a mapping specification, you may need to configure complex filters and rules. You can create separate mapping specifications to break down the complex logic. You can add each mapping specification as a source to develop the logical flow.
Mapping Specification Development
Develop a mapping specification to define the business logic that transforms data from source to target. After you develop the mapping specification, you can load the results of the mapping specification to a target or export the mapping specification results or logic to share with other analysts or developers.
Complete the following steps to develop a mapping specification:
- 1. Create a mapping specification.
- 2. Configure the mapping specification to add aggregators, filters, joins, lookups, rules, and sources and edit the aggregators, filters, joins, lookups, rules, and target.
- 3. Validate the mapping specification.
- 4. Preview the mapping specification results.
- 5. After you develop a mapping specification, you can complete the following steps:
- - Share the mapping specification with a developer.
- - Load the results of the mapping specification to a target.
- - Export the mapping specification logic as documentation to Excel.
- - Export the mapping specification logic to PowerCenter.
- - Export the mapping specification logic as a virtual table.