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
- 2843 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
How to create the source and target database connections in server manager?
What does “tail –f” command do and what is its use as an Informatica admin.
What is informatica?
What are the restrictions of union transformation?
Sequence generator, when you move from develoment to production how will you reset
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What is xml source qualifier transformation in informatica?
What are the components of workflow manager?
What is DR strategy for Informatica project?
Did u used latest transformations of 8.6.0? for what?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
Is it possible to revert a global repository to local one and why?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
How does the aggregator transformation handle null values?
What are the main issues while working with flat files as source and as targets ?
