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 decode in static cache?

0 Answers  

How to convert flat file into xml file? How to tune joiner?

2 Answers   Accenture,

In a table, 4 person having same salary. How to get Third person record only?

15 Answers  

Hi frndz, "while i am going to run the infotmatica power designer,he ask the id and password ",then i enterd the id and passwd , at that time i got the error as " failed to connect repository " ?

3 Answers  

Explain the features of connected and unconnected lookup.

0 Answers  




What are the main issues while working with flat files as source and as targets ?

0 Answers   Informatica,

What is the function of aggregator transformation?

0 Answers  

How to view and Generate Metadata Reports?

1 Answers  

What are the different threads in DTM process?

1 Answers  

What are the basic requirements to join two sources in a source qualifier transformation using default join?

0 Answers   Informatica,

I want expect first and last record remaining all records will be loaded into target? which transformations we can use?

6 Answers   Cap Gemini, CTS,

What is incremental aggregation and how it is done?

8 Answers   JPMorgan Chase, TCS,

For more Informatica Interview Questions Click Here
Categories