What is the difference between IN and Exists in Oracle?
Answer Posted / ram
exists improves the performance because it returns boolian
value where as 'in' is not...so exists simplyfies internal
calculations....
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
what is the size of your data warehousing?
What is workflow manager?
What does update strategy mean, and what are the different option of it?
Where do we use mapping variables in informatica?
What is an expression transformation?
Mention few advantages of router transformation over filter transformation.
What the difference is between a database, a data warehouse and a data mart?
What does command task mean?
r u done any partitions in ur project?
How might one distinguish in the case of mapping is right or not without associating session?
list out all the transformations which use cache?
What are the conditions needed to improve the performance of informatica aggregator transformation?
Define mapping and session?
design of staging area?
What are the types of data warehouses?