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
7235 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 can you join 3 tables? Why cant you use a single Joiner to join 3 tables.

1 Answers

Which transformation can be created only as reusable transformation but not as non-reusable transformation?

1 Answers Informatica,

Difference between STOP & ABORT in Informatica.

3 Answers Accenture, Wells Fargo,

I have some rows in source.I have to map half rows to one target and half rows to another target.i.e you wont know how many records in source.?Implement a mapping?

1 Answers Franklin Templeton,

If there are more than one sessions running parallel in a worklet, which will be the last session ?

2 Answers

How can you define user defied event?

0 Answers

what is threshold error in informatica?

1 Answers TCS, Wipro,

How to read data from flat file source if the data is in paragraph format?

2 Answers Wipro,

how many new transformations are introduced in 8.1 which are not available in 7.1? any new transformation in 8.6?

2 Answers emc2,

we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks

3 Answers TCS,

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

3 Answers

what is the method of error handling when session is running?

1 Answers TCS,

For more Informatica Interview Questions Click Here