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

Why touse stored procedure in ETL Application?

2 Answers

8.what is mapplet ?give example?

2 Answers

what is DSS?

3 Answers

How can i send first half of the records to one target and Remaining to other target?

10 Answers TCS,

What is critical mapping?

2 Answers

I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?

5 Answers Span Systems,

what we require for D.modelling?

1 Answers

what are the limitations for bulk loading in informatica for all kind of databases and transformations?

3 Answers Accenture, CSC,

The question was on time stamp. what is the difference between HH and HH24 when to use when.

0 Answers Nationwide,

What are the different transaction levels available in transaction control transformation?

0 Answers Informatica,

Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptno; Avg (sum (Sal)) o f all deptno= 9675 Deptno, sum (Sal) 10 8750 20 10875 30 9400

7 Answers iGate,

How can you use an Oracle sequences in Informatica? You have an Informatica sequence generator transformation also. Which one is better to use?

1 Answers

For more Informatica Interview Questions Click Here