What is the exact difference b/w IN and EXIST in Oracle..?
- 4 Answers
- 7814 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / pavan_615
IN- sub Query - it will be executed once for the full query
Exist - Co-related sub Query - it will be executed for each
row.-- exist will me faster when you are working with big
tables.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain in detail scd type 2 through mapping.
What are the different clients of powercenter?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What is the need for an etl tool?
Define enterprise data warehousing?
What are junk dimensions?
How to go to the older version for a mapping?
What are the static cache and dynamic cache in informatica?
Do you find any difficulty while working with flat files as source and target?
How are the sources and targets definitions imported in informatica designer?
How can we create index after completion of load process?
What is a repository manager?
What is a predefined event?
How many numbers of sessions can one group in batches?
What is exclusive and normal mode for repository services?
