Answer Posted / srinivas
there are four types of joins in Informatica
1) Normal join -- Equi join
2) Master join -- Left outer join
3) Detail join -- Right outer join
4) Full outer join -- Full outer join
| Is This Answer Correct ? | 9 Yes | 7 No |
Post New Answer View All Answers
What is enterprise data warehousing?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What is meant by active and passive transformation?
What are batches?
How to update source definition?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What is the scenario which compels informatica server to reject files?
During the running session, output files are created by informatica server. Enlist few of them.
What is meant by query override?
Design a mapping to load a target table with the following values from the above source?
Explain informatica architecture - version 8 / 9
What is repository manager?
Performance tuning( what you did in performance tuning)
Design a mapping to load the cumulative sum of salaries of employees into target table?
What is a surrogate key?