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
- 6095 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
What is pmcmd command?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Why is sorter an active transformation?
Where is metadata stored?
Make a note of the quantity vaults made in informatica?
waht type of interface is used for testing the data in informatica
Explain transaction control transformation in informatica
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What is a filter transformation?
What is meant by incremental aggregation?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What is the difference between stop and abort in informatica
Different circumstance which drives informatica server to expel records?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
How to create Target definition for flat files?
