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
What is a passive transformation?
What are the issues you have faced in your project? How did you overcome those issues?
Enlist the various types of transformations.
If informatica has its scheduler why using third party scheduler?
What is option by which we can run all the sessions in a batch simultaneously?
According to his methodology what all you need before you build a datawarehouse
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Which development components of informatica have the highest usage?
What is meant by lookup transformation? Explain the types of lookup transformation?
Explain dynamic target flat file name generation in informatica
Explain lookup transformation is active in informatica
What is the need of an ETL tool?
What is the session task and command task?
How to delete duplicate row using informatica?
Where do we use mapping variables in informatica?
