What r the types of maping wizards that r to be provided in Informatica?

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.

Getting Started Wizard. Creates mappings to load static fact and dimension tables, as well as 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.

  • Interview Candidate
  • 2
  • 4719

Showing Answers 1 - 2 of 2 Answers

raj

  • Apr 13th, 2007
 

Inf designer :

Mapping ->  wizards -->  1) Getting started -->Simple pass through mapping
                                                                     -->Slowly growing target

                                        2) slowly changing dimensions---> SCD 1 (only recent  values)
                                                                                        --->SCD 2(HISTORY using flag or version or time)
                                                                                        --->SCD 3(just recent values)
          

one  important point is  dimensions are 2  types    

1)slowly growing targets
2)slowly changing dimensions.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions