Interested to Buy Any Domain ? << Click Here >> for more details...
what is left outer join?
- 3 Answers
- 8465 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 |
i have one table like cust_id ph1 ph2 ph3 1002 9290123526 97671927210 9876545232 we use Normalizer wt is o/p? sue normalizer we can generate three tables in single table/
I am hvaing SOURCE as 1000,null,null,null null,2000,null,null null,null,3000,null null,null,null,4000 Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
what is scd?
I need an oracle query for convert Char to Integer?. Can any one help me how to do this?
What is a connected transformation?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
SO many times i saw "$PM parser error " .what is meant by PM?
What differs when we choose the sorted input for aggregator transformation?
What is the method of seperating unique and duplicate records in session level?
2 Answers Emphasis, JBL, Wipro,
What are events in workflow manager?
How to load query faster,so that It will take less time to load?
Teradata 
