Interested to Buy Any Domain ? << Click Here >> for more details...
what is left outer join?
- 3 Answers
- 8594 Views
- L&T, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mahi
It will take all the records form detailed table,
and matching records form master table.
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / 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 |
Answer / rashid equbal
It will take all the records form detailed table,
and matching records from master table.
| Is This Answer Correct ? | 0 Yes | 0 No |
what is mapping optimization? wat are the techniques for tat
Explain the pipeline partition with real time example?
In real time scenario where can we use mapping parameters and variables?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
enterprise datawarehouse your project phase by phase explain?
if soource is having 10 records how will u insert 20 records to target
Is informatica power center designer has 64 bit support?
Explain the informatica workflow?
What is the difference Between Mapping parameter and variable
Please create a mapping where I have source which has one column with name like Aman_Gupta Rakesh_Mehra Sachin_More I want the target field should contain the name in reverse order i.e Gupta_Aman Mehra_Rakesh More_Sachin. Can you please tell me what transformation would be needed to do this.
what is left outer join?
can any one explain me about junk dimension
Teradata 
