Interested to Buy Any Domain ? << Click Here >> for more details...
How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.
- 1 Answers
- 2755 Views
- I also Faced
- E-Mail Answers
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 exclusive and normal mode for repository services?
What is lookup transformation?
How to update a particular record in target with out running whole workflow?
Differentiate between sessions and batches?
What is Cognos script editor?
explain abt ur project architecture?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
Is there any way to read the ms excel datas directly into informatica?
In warehouses how many schemas are there?
What is domain in terms of informatica?
What is primary and backup node?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What is the session task and command task?
What is the commit type if you have a transaction control transformation in the mapping?
