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 |
1)what is the use of bottlenecks in informatica. 2)where we are use shellscripting. 3)what meant by informatica.
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
how can we use sorter transformation in joins?
I want to run a workflow which consist of 3 sessions. But wat my question is. 1st session should run on DB1if the first session is successful then 2 session should run on db2 and 3rd session should run on DB3 envronments. i want 3 different wf logs. it shoul not override on one log?
What are the joiner caches?
i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow
How can u insert o ne row in the target if that row does not exists in the target and update if it exists
in my source i have 100 records, and 3 targets, i want to load 1st record into 1st target,2nd record into 2nd target,3rd record into 3rd target again 4th target into 1st target and vice versa,how to achieve this?
how can we perform incremental aggregation?explain with example?
How to load only the first and last record of a flat file into the target?
can every transfomation reusable?how?
what is the main advantage of unconnected lookup