Interested to Buy Any Domain ? << Click Here >> for more details...
what is left outer join?
- 3 Answers
- 8272 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 |
In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?
How to use procedural logic inside infromatica?
i have two source data there is no pk,fk how to join the two sources
If session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?
Hi i am new to Informatica. I have few question's in Informatica. Can any one respond, it will be appricaited. Q.Is Flat File Contains the Dynamic Cache?
How to load last 10 records of flat file in to the target?
WAT IS THE MEANING OF UPGRADTION OF REPOSITORY?
What are Target Options on the Servers?
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
What is a pre-defined event and user-defined event?
How to jion 2 tables, without using any condition?
Is LOAD MANAGER AND LOAD BALANCER same in informatica?
Teradata 
