Interested to Buy Any Domain ? << Click Here >> for more details...
what is left outer join?
- 3 Answers
- 8412 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 |
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
In joiner, how to load Master table in Target?
A Main workflow "wkf_Main" has multiple sessions (S1, S2...., can I make changes and promte one session (S5) at any time or have to promote whole Workflow "wkf_Main" every time?
Can any body tell about the (UTC) unit test cases with the examples in informatica.
WAT IS THE MEANING OF UPGRADTION OF REPOSITORY?
which transformation uses cache?
what is confirmed dimension?
Where do we use mapping variables in informatica?
What could be the possible resons of locks by user?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
write s sql query following table some duplicate present i want unique one column duplicate another column display? name id a 1 a 1 b 2 b 2 c 3 i want the required output like unique duplicate name id name id a 1 a 1 b 2 b 2 c 3
in flatfile target how can u create header and footer plese give me the comands how will u write in session properties
Teradata 
