How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.
- 1 Answers
- 2065 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
Can anyone tell me the new features in Informatica 9 Version?
How can we create index after completion of load process?
What is the function of look up transformation?
where to store informatica rejected data? How to extract the informatica rejected data?
How can one identify whether mapping is correct or not without connecting session?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What are connected or unconnected transformations?
What do you understand by a term domain?
What is a sorter transformation?
Explain the types of transformations?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Do you find any difficulty while working with flat files as source and target?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What is DR strategy for Informatica project?
