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

How do you migrate data from one environment to another?

0 Answers

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

0 Answers IBM,

What is the difference between informatica 8.x and 9.x

1 Answers Wipro,

Target increases every day even though no new record was inserted

0 Answers Accenture,

what is lookup ?

7 Answers

suppose i have source 101 a 101 b 101 c 101 d i want target like 101 abcd how will u achive this please give me the answer

5 Answers ITC Infotech, TCS,

In Flat file Input is A B C I need output like this A A A B B B C C C. How will u achieve this?

5 Answers iNautix,

How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?

4 Answers

How you know when to use a static cache and dynamic cache in lookup transformation?

0 Answers

What is the capacity of power cube?

1 Answers

what is shared lookup&persistent lookup?

4 Answers Accenture, Cap Gemini,

how i will stop my workflow after 10 errors

1 Answers HP,

For more Informatica Interview Questions Click Here