Mapping Specifications Overview
A mapping specification describes the movement and transformation of data from a source to a target. Use a mapping specification to collaborate on projects and define business logic that populates a target with data. You can then leverage that target to report on the data.
A mapping specification is a Design asset. Create mapping specifications in the Design workspace of the Analyst tool.
Based on the business logic that you want to use, you can create mapping specifications with multiple sources, with another mapping specification as a source, or with no target. You can also share the mapping specification logic with other analysts and developers.
After you create a mapping specification, you can view or edit the mapping specification. You can add aggregators, filters, joins, lookups, rules, rule definitions, and sources to a mapping specification to develop the business logic. You can edit the aggregators, filters, joins, lookups, rules, and target in a mapping specification.
After you create the mapping specification, you can perform the following tasks:
- •Run a column profile on the mapping specification source and target to analyze the structure and quality of data.
- •Run a SQL query against source or target columns in a mapping specification and view the query results in a data preview.
- •Load the results of the mapping specification to a relational or flat file target.
- •Export the mapping specification logic to Microsoft Excel to document and share the mapping specification logic with other analysts and developers.
- •Export the mapping specification logic to PowerCenter to share the mapping specification logic with a PowerCenter developer.
- •Export the mapping specification logic as a virtual table that analysts and developers can use to run SQL queries against the data.