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 |
How the informatica server sorts the string values in Rank transformation?
Explain what are the different versions of informatica?
What is the need of an ETL tool?
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
I want load the data into target with out 1st and last record.
how to improve performence by using sorted input in aggrigator t/r.
What is the advantage of persistent cache? When it should be used.
In which transformation you cannot drag ports into it?
HOE DO U IMPLIMENT SCHEDULING IN INFORMATICA?
How can we improve session performance in aggregator transformation?
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?
Which kind of index is preferred in DWH?