The Designer provides two mapping wizards to help you create mappings quickly and easily. Both wizards are designed to create mappings for loading and maintaining star schemas, a series of dimensions related to a central fact table. You can, however, use the generated mappings to load other types of targets.
You choose a different wizard and different options in each wizard based on the type of target you want to load and the way you want to handle historical data in the target:
After using a mapping wizard, you can edit the generated mapping to further customize it.
Using the Getting Started Wizard
The Getting Started Wizard creates mappings to load static fact and dimension tables and slowly growing dimension tables.
The Getting Started Wizard can create two types of mappings:
The following table describes the getting started mapping types:
Using the Slowly Changing Dimensions Wizard
The Slowly Changing Dimensions Wizard creates mappings to load slowly changing dimension tables:
The following table describes the slowly changing dimension mapping types:
Choosing Sources for the Mappings
Use the following sources with a mapping wizard:
You cannot use COBOL or XML sources with the mapping wizards.
When you select a source for a mapping, the mapping wizards display all available sources by source name. The Designer can optionally display sources and target definitions by business name, rather than source and target name. Even when this option is selected, mapping wizards display sources by source name.
The Mapping Wizard cannot import a source when a column name uses an SQL keyword. When the Mapping Wizard encounters an SQL keyword used as a column name, it prompts you to choose another source. If you want to use a source with a column using an SQL keyword, create the mapping in the Mapping Designer.
The mapping wizards also complete the following based on the selected source:
Using The Designer
Working With Sources
Working With Flat Files
Working With Targets
Mapping Parameters And Variables
Working With User-defined Functions
Using The Debugger
Viewing Data Lineage
Managing Business Components
Creating Cubes And Dimensions
Using The Mapping Wizards
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.