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

Answer Posted / laxmi soujanya

10*5=50 records

this is cartesian product

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

difference between informatica 8.1.1 and 8.6

3244


What is a pre-defined event and user-defined event?

577


How to improve the performance of a session using sorter transformation?

688


What is target load order?

805


How to join three sources using joiner?

573






What is the fact table?

590


Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

7767


EXL informatica Questions

936


Explain how to import oracle sequence into informatica?

590


Have you worked with/created Parameter file

1226


what is the size of u r source(like file or table)?

1818


how tokens will generate?

1738


my source is junk data how will u remove that junk data by using unix please any one replay me

3241


How would you copy the content of one repository to another repository?

557


How to load the name of the current processing flat file along with the data into the target using informatica mapping?

697