Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

what is left outer join?

Question Posted / prasuna

Answers were Sorted based on User's Feedback



what is left outer join?..

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

what is left outer join?..

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

what is left outer join?..

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

Post New Answer

More Informatica Interview Questions

Explain Dataware house architecture .how data flow from intial to end?

0 Answers   Keane India Ltd,

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

0 Answers  

what is song in infrmatica...?

0 Answers   CTS,

Target increases every day even though no new record was inserted

0 Answers   Accenture,

While importing the relational source defintion from database,what are the meta data of source U import?

1 Answers  

How to Display top 2 salaries for each department WITHOUT using Rank Transformation And WITHOUT using SQL queries in source qualifier.

3 Answers   Eureka Forbes,

how can send duplicate records to one tableand non duplicate records to one table with simple clear mapping?

5 Answers   DELL,

How the facts will be loaded? explain

2 Answers   HCL,

what is the use of Java Transformation in Informatica 8.x?

2 Answers   TCS,

my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yahoo.com 2000 i want load my data to the target is cno cname sal 100 rama 1000 200 karuna 2000 plz send the answer

5 Answers   IBM, TCS,

explain about unit testing? in real time?

0 Answers   L&T,

what is the main advantage of unconnected lookup

2 Answers   Cap Gemini,

For more Informatica Interview Questions Click Here
Categories