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
Differentiate between sessions and batches?
Why update strategy and union transformations are active?
What are the types of lookup transformation?
How can we use mapping variables in informatica?
What is fact table? Explain the different kinds of facts.
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What is substr in informatica?
Enterprise data warehouse your projects phase by phase explain?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What is repository manager?
What is transformation?
Define update strategy?