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

what is the location of parameter file in informatica?

1 Answers   TCS,

Suppose we do not group by on any ports of the aggregator what will be the output?

0 Answers  

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 meant by active and passive transformation?

0 Answers  

What is best approach to load 100 different source files (Different structure) to differet target tables ?

2 Answers   IBM, TCS,

Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?

2 Answers   Deloitte,

can we have to do changes in session property when we are dynamically generating target files?

3 Answers   Wipro,

what happens when a batch fails?

3 Answers  

Which version configuration tool used in ur project?

0 Answers   CTS, TCS,

List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys

1 Answers  

how do u move the code from development to production?

3 Answers  

hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

0 Answers  

For more Informatica Interview Questions Click Here
Categories