Sign Up Login


  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

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 domain in terms of informatica?

0 Answers  

Name at least 5 different types of transformations used in mapping design and state the use of each.?

0 Answers   Informatica,

What is Performance tuning in Informatica?

1 Answers   CTS, GE, TCS,

Explain joiner transformation in informatica

0 Answers   Informatica,

Why the workflow is failed after running two hours in informatica?

1 Answers   GE,

How to generate sequence numbers?

0 Answers  

how to remove staging area

1 Answers  

Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?

2 Answers  

hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks... Send me----: raghukrams@yahoo.com

0 Answers  

Do you have to change the reject file b4 using reject loader utility.

1 Answers  

how we can load rejected record's at run time?(not through bad files)

0 Answers   TCS,

Why we use stored procedure transformation?

4 Answers  

For more Informatica Interview Questions Click Here
Categories