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

Hi experts,
table 1 has 10 records, table 2 has 5 records
select * from table1, table2;
What is the output for this query???....plz answer

Question Posted / baladevshree

Answers were Sorted based on User's Feedback



Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is t..

Answer / priyasen

(10*5) 50 records
this kind of query gives us Cartesian product

Is This Answer Correct ?    68 Yes 0 No

Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is t..

Answer / laxmi soujanya

10*5=50 records

this is cartesian product

Is This Answer Correct ?    5 Yes 0 No

Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is t..

Answer / dinesh

ans:select * from table 1,table2?

45 records(cartisan product)

Is This Answer Correct ?    0 Yes 31 No

Post New Answer

More Informatica Interview Questions

What are the basic needs to join two sources in a source qualifier?

3 Answers  

How to load last 10 records of flat file in to the target?

5 Answers   iNautix,

Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.

1 Answers  

Hi, Can you please send me the Informatica 8 certification exam dumps to my email id rwork.san@gmail.com Thanks, Revathi.

6 Answers   CTS,

What is the benefit of session partitioning?

0 Answers  

What does reusable transformation mean?

0 Answers  

how to remove staging area

1 Answers  

Limitation of REPLACESTR. Is there any character limitation to it.

1 Answers   CTS,

What is rank transformation?

0 Answers  

What is the Difference between PowerPlay transformer and power play reports?

1 Answers  

we r using aggregator with out using groupby?

7 Answers   HSBC, Principal Finance,

Can we insert ,update ,delete in target tables with one update strategy tran.?

2 Answers   Zensar,

For more Informatica Interview Questions Click Here
Categories