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
7364 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

What is data caches/ index caches?

0 Answers

write a sql query following table? col1 col2 1 2 1 2 1 2 3 4 3 4 5 6 i want the output like unique duplicate col1 col2 col1 col2 1 2 1 2 3 4 1 2 5 6

1 Answers Cap Gemini,

i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .

6 Answers Emphasis,

What is diff between connected and unconnected lookup?

5 Answers BirlaSoft, Blue Star Infotech,

How can u stop a batch?

2 Answers

source table have single column single record having with single space. load that source record into trg . trgt having two columns and the SOURCE TABLE LIKE COL1 BHANU PRASAD TRGT TABLE COL1 COL2 IN THAT LOAD THE RECORD IN THE trgt table LIKE COL1 COL2 BHANU PRASAD HOW ? TELL ME PLZ

2 Answers Wipro,

What is informatica worklet?

0 Answers

What are the new features of the server manager in the informatica 5.0?

1 Answers

What is a sorter transformation?

0 Answers Informatica,

What is deployemnt groups, Lables, query and dynamic deployment group.

1 Answers IBM, SVP,

I have source data like this col1 col2 col3 5 3 8 6 2 9 7 1 10 and i want to get target as col1 col2 col3 5 1 8 6 2 9 7 3 10 which transformation i have to use and how?

3 Answers

what is data modelling? what are types of modelling?In which suituation will use each one?

1 Answers Accenture,

For more Informatica Interview Questions Click Here