Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1

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

3 Answers
7080 Views
TCS, I also Faced
E-Mail Answers

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

Change Data Capture in Informatica,using Incremental Aggregation.How can i identify the these data in Target table.

2 Answers

How to load the data from a flat file into the target where the source flat file name changes daily?

0 Answers Informatica,

PLS REAL TIMERS IAM WAITING FOR FAVOROBLE REPLY..REGARDING ETL TESTING INFORMATION...ETL TESTER NEEDS ETL DEVOLPMENT KNOWLEDGE OR NOT..?. IF HE NEED DEVLPMNT KNOW WHAT HE LEANR FIRST... AS A DEVOLOPER U KNOW THE ETL TESTING PROCESS.. PLS EXPLAIN IN DETAIL THANK U

2 Answers

how may sources can be used in a mapping at a time?(limit)

6 Answers IBM,

Explain the pipeline partition with real time example?

0 Answers Informatica,

what is mystery dimension?

1 Answers

How to eliminate duplicates in FF and oracle both

3 Answers CSC,

when informatica 8 series released ?

1 Answers IBM,

What is Target Update Override? What is the Use ?

8 Answers Patni,

From where we can start or use pmcmd?

3 Answers

how can run the wf through pmcmd commend? write script?

2 Answers Cap Gemini,

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

For more Informatica Interview Questions Click Here