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:
Getting Started Wizard.
Creates mappings to load static fact and dimension tables and slowly growing dimension tables.
Slowly Changing Dimensions Wizard.
Creates mappings to load slowly changing dimension tables based on the amount of historical dimension data you want to keep and the method you choose to handle historical dimension data.
After using a mapping wizard, you can edit the generated mapping to further customize it.