What are the types of maping wizards that r to be provided
in Informatica?
Answers were Sorted based on User's Feedback
Answer / nagarjuna
Two mapping wizards are there.
1. Simple pass through
2. slowly changing dimensions
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / swetha
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.
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain the features of connected and unconnected lookup.
suppose my source is 101 a 1o1 b 101 c 101 d i want target like that 101 abcd how will u achive this please give me the answer
How can one identify whether mapping is correct or not without connecting session?
How would you copy the content of one repository to another repository?
How do you load alternate records into different tables through mapping flow?
I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.
Mapplets can you use an active transformation in a mapplet,
i have a flat file and the file s are like below ****%%^^@@@G**@#A@#$N*&^E%^S@#h@@@##$$ IN THIS FORMATE Means un limited special charecter between and sides of the string data..output should be(GANESH) HOW YOU HANDEL THIS TYPE OF RECORDS,,COZ U DON"T KNOW WHERE AND WHAT ARE THE SPECIAL CHARACTERS IN BETWWEN THE NAME...
what is the architecture of any Data warehousing project?
Suppose we do not group by on any ports of the aggregator what will be the output?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What is an active transformation?