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

expain about the tune parameters?

0 Answers   TCS,

Can any one explain or sujjest some sites for scd mappings.Thank you

1 Answers   Wipro,

i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informatica

2 Answers   HP,

How union transformation is used?

0 Answers  

On lookup on any table we can get only a)any value or b)last value but if i need both duplicate values How can i achieve?

3 Answers  

major difference between normal loading and bulk loading?

6 Answers  

if we hav 10 records in a file, can we get first record from it by using Aggregator with out using Groupby Port in it?If Yes..let me know the answer plz!!!

8 Answers   IBM,

How to generate a single mapping for both the historical and incremental load.

2 Answers   CSC, TATA,

What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

0 Answers  

Which kind of index is preferred in DWH?

3 Answers  

When will you use SQL override in a lookup transformation?

1 Answers  

whats the logic to load the lower level of granularity of data to fact table.

0 Answers   IBM,

For more Informatica Interview Questions Click Here
Categories