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

i have two tables,table 1 having 2 columns and 3
rows,table2 having 3 columns and 2 rows.what is the output
if i do left outerjoin,full outer join,right outer join?

Question Posted / bharathi

Answers were Sorted based on User's Feedback



i have two tables,table 1 having 2 columns and 3 rows,table2 having 3 columns and 2 rows.what is t..

Answer / pradosh

in table data like following
left table1 right table2
c1,c2 c3,c4,c5
1,2 1,1,10
4,5 6,5,12
7,8 matching columns c1 and c3

Right outer join c1,c2,c3,c4,c5
1,2,1,1,10.
-,-,6,5,12.
Left outer join 1,2,1,1,10.
4,5,-,-,-.
7,8,-,-,-.
full outer join 1,2,1,1,10.
4,5,-,-,-.
7,8,-,-,-.
-,-,6,5,12.

'-' indicates null in above table

Is This Answer Correct ?    7 Yes 1 No

i have two tables,table 1 having 2 columns and 3 rows,table2 having 3 columns and 2 rows.what is t..

Answer / vijaya

in table data like following
left table1 right table2
c1,c2 c3,c4,c5
1,2 1,1,10
4,5 6,5,12
7,8 matching columns c1 and c3

left join c1,c2,c3,c4,c5
1,2,1,1,10.
-,-,6,5,12.
right join 1,2,1,1,10.
4,5,-,-,-.
7,8,-,-,-.
full outer 1,2,1,1,10.
4,5,-,-,-.
7,8,-,-,-.
-,-,6,5,12.

'-' indicates null in above table

Is This Answer Correct ?    6 Yes 5 No

Post New Answer

More Informatica Interview Questions

what we require for D.modelling?

1 Answers  

Please let me know how to make encryption and decryption with example?

0 Answers  

Can you generate sequence numbers without using the sequence generator transformation?

0 Answers  

what are the challenge face in u r project?explain me

1 Answers   iGate, TCS,

What is flashback table ? Advance thanks

0 Answers   Puma,

How can you differentiate between powercenter and power map?

0 Answers  

Can you please mail me a copy of Informatica Certification Exam dumps to sriveniv@hotmail.com

0 Answers  

what is mean by throghput? in informatica

3 Answers   Cap Gemini,

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

0 Answers  

my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same

2 Answers   KPIT,

What is the meaning of decode in informatica?

0 Answers  

what are surrogate keys?

5 Answers  

For more Informatica Interview Questions Click Here
Categories