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
- 3 Answers
- 6108 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / priyasen
(10*5) 50 records
this kind of query gives us Cartesian product
| Is This Answer Correct ? | 68 Yes | 0 No |
Post New Answer View All Answers
Explain sessions and how many types of sessions are there?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
What are the features of complex mapping?
What is the function of look up transformation?
Which files are created during the session rums by informatics server?
Please let me know how to make Data masking in informatica..
What are the issues you have faced in your project? How did you overcome those issues?
What are the uses of etl tools?
What is rank transform?
How to extract sap data using informatica? What is abap? What are idocs?
What is informatica? Why do we need it?
What is the command used to run a batch?
waht type of interface is used for testing the data in informatica
I have a flat file, want to reverse the contents of the flat file
Explain the mapping variable usage example in informatica
