How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.
Answer Posted / 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 View All Answers
What is the format of informatica objects in a repository?
Why sorter is an active transformation?
What are the conditions needed to improve the performance of informatica aggregator transformation?
EXL informatica Questions
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What's the layout of parameter file (what does a parameter file contain?)?
What is the function of union transformation?
pmscmd startworkflow -sv
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
explain abt ur project architecture?
hi real timers . iam waiting for ur reply regarding ETL TESTING
How we can create indexes after completing the loan process?
Explain why we use partitioning the session in informatica?