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

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 is a repository manager?

0 Answers  


When do we use dynamic cache and static cache in connected and unconnected lookup transformations?

3 Answers  


How many numbers of sessions can one group in batches?

0 Answers  


Had any one faced informatica(ETL/Developer), Datawarehouseing interview in UK. Than plz help me (i have any exprience of 3yrs informatica,datawarehousing,oracle,teradata) 1.hw the procedure will b here 2. wht type of question's they will b asking. 3.In which area they concertate more. since this is the first time im facing interview in UK. plz help ASAP.it will b a great help for me thanks to All in Advance

2 Answers  


what is difference between COM & DCOM?

1 Answers   Satyam,


we have 6 records in source , i need 2nd record in one target and 5th record in one target or 2nd & 5th record in same target.

8 Answers  


can we override a native sql query within informatica? How do we do it?

0 Answers  


wht is full process of Information source to target just like stg to productuon and development

1 Answers   Informatica,


What are the basic requirements to join two sources in a source qualifier transformation using default join?

0 Answers   Informatica,


What are the features of complex mapping?

0 Answers  


What is CHECK-IN CHECK-OUT. Please explane me?

3 Answers   TCS,


Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

0 Answers  


Categories