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

How the informatica server sorts the string values in Rank transformation?

1 Answers   Informatica,


Explain what are the different versions of informatica?

0 Answers  


What is the need of an ETL tool?

0 Answers   Informatica,


I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records

5 Answers   Patni,


I want load the data into target with out 1st and last record.

5 Answers   Yash Technologies,






how to improve performence by using sorted input in aggrigator t/r.

2 Answers  


What is the advantage of persistent cache? When it should be used.

1 Answers   Wipro,


In which transformation you cannot drag ports into it?

0 Answers   Informatica,


HOE DO U IMPLIMENT SCHEDULING IN INFORMATICA?

7 Answers   Patni, Wipro,


How can we improve session performance in aggregator transformation?

0 Answers   Informatica,


Source --------- eno , ename, sal 001,ank,1000 002,behe,2000 003,raj,2500 Target ------- header :DDMMYYYY24MMSS timestamp body: 001,ank,1000 002,behe,2000 003,raj,2500 footer: count(eno),sum(sal) how to implement the same in a FF tgt?

2 Answers   CTS,


Which kind of index is preferred in DWH?

3 Answers  


Categories