Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / jay
For eg.
Select M.*, D.* from
Master M LEFT OUTER JOIN Details D
on M.ID = D.ID
In the above query we get all the records from Master table and matching records from Detail table.
In simple it takes all rows from the table which is left of the join and matching records from table which is in other side of the join.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Explain what transformation and how many are there in informatica?
How to generate sequence numbers?
Describe the impact of several join conditions and join order in a joiner transformation?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Which is the t/r that builts only single cache memory?
What is intricate mapping?
How identifying bottlenecks in various components of informatica and resolving them?
How many transformations can be used in mapplets.
Enlist the various types of transformations.
what is mean by complex business rule ?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Parameter and variable differences
can u any challenge your project?
Different qualification between a related rotate toward the sky and isolates look upward?
