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 |
What is the difference between Bad file and Reject file? and Where u can see the Reject file? What records stored in Reject file?
What is operational data source (ODS)?
What is a difference between complete, stop and abort?
Comment on significance of oracle 9i in informatica when compared to oracle 8 or 8i?
What do you mean by filter transformation?
what is the difference between mapplet & stored procedure?
i have 50500 records in my source.if wf run for the first time it will load 1000 records into 1 tgt,if runs second time it will load to another tgt.targets are FF and it is need to be created dynamically.how many tgt will be created and how?
if we have certain records,if i need to get 5 th rec for the first time to the target,when i run it for next time,i need to get 6th rec...like that it should process.what wil be the procedure to achieve it??
Mention some types of transformation?
Explain lookup transformation source types in informatica
What are ETL Tools?
Major difference between SQL override and Lookup Sql override