How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.



How can you join 3 tables? Why cant you use a single Joiner to join 3 tables...

Answer / ranjan

Sql only allow us to join only two tables at a time because intersection/union methodology can only possible in two tables .

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

What is different between informatica version 8 and 9 version

1 Answers   Cognizant, IBM,


What exactly mentioned in High level design document.can somebody explain me sequentialy.

1 Answers   IBM,


What is informatica worklet?

0 Answers  


How do you load only null records into target?

0 Answers  


what is difference between mapping and mapplet ?

2 Answers   TCS,


What is a pre-defined event and user-defined event?

0 Answers  


what is the diff b/w target load plan and cbl?

3 Answers   CTS, iGate,


without dynamic lookup transformation how to insert new rows and update existing rows?

7 Answers   Cap Gemini,


how i will stop my workflow after 10 errors

2 Answers   HP,


what is casual dimension?

6 Answers   IBM,


Differences between version 7.x and 8.x.

0 Answers   Accenture, Cognizant,


any body can say about all versions of informatica ?how many versions ?

2 Answers  


Categories