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

I have some rows in source.I have to map half rows to one target and half rows to another target.i.e you wont know how many records in source.?Implement a mapping?

1 Answers   Franklin Templeton,


Is it possible to have "5 source & 5 Target" in single mapping?

1 Answers  


What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

0 Answers   IBM,


After we make a folder shared can it be reversed?Why?

2 Answers   Accenture,


hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

0 Answers   IBM,






what are the settiings that u use to cofigure the joiner transformation?

2 Answers  


What are the guidelines to be followed while using union transformation?

0 Answers   Informatica,


What are junk dimensions?

0 Answers  


what is curr val use for in sequence generator?

2 Answers   Emphasis,


what is difference between mapping and mapplet ?

2 Answers   TCS,


How can we use batches?

0 Answers  


select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?

5 Answers   Puma,


Categories