How many joins in Informatica

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


Please Help Members By Posting Answers For Below Questions

What are the tasks that source qualifier perform?

633


What is an Integration service in Informatica?

705


What does update strategy mean, and what are the different option of it?

590


I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

1587


What is complex mapping?

641






What is confirmed fact in dataware housing?

5693


What is the difference between router and filter?

651


What is the sequence generator transformation in informatica?

613


Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

1872


what is SDLC way of code development?

1561


Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1539


what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

1876


What are the modules in Power Center

1240


Is it possible to revert a global repository to local one and why?

615


What is the use of an aggregator cache file?

691