what is the mechanism of the Master-Detail joining
condition?
Answer Posted / jay
I guess it is a Left OUTER join.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What are the different ways to implement parallel processing in informatica?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
In development project what is the process to follow for an etl developer from day1
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
How to generate or load values in to the target table based on a column value using informatica etl tool.
What are the types of lookup transformation?
Describe the impact of several join conditions and join order in a joiner transformation?
Can you use flat files in Mapplets.
How many types of sessions are there in informatica.please explain them?
Did u used latest transformations of 8.6.0? for what?
Explain sessions?
When do you use sql override in a lookup transformation?
What is the scenario which compels informatica server to reject files?
What is the difference between Active and Passive transformation?
What are the types of schemas we have in data warehouse and what are the difference between them?