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
Slowly changing dimensions, types and where will you use them
What is update strategy transform?
pmscmd startworkflow -sv
What differs when we choose the sorted input for aggregator transformation?
What are the mapping parameters and mapping variables?
How can we store previous session logs?
What are the tuning techniques you applied during your last project
Differentiate between router and filter transformation?
What if the source is a flat-file?
Different sorts of metadata that stores in the storage facility?
What is workflow manager?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How to load last n records of file into target table - informatica
Enlist the tasks for which source qualifier transformation is used.
Briefly define reusable transformation?
