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 are the designer tools for creating transformations?
What are the types of caches in lookup?
Why sorter is an active transformation?
What is domain in terms of informatica?
What is a filter transformation and why it is an active one?
Did u used latest transformations of 8.6.0? for what?
Slowly changing dimensions, types and where will you use them
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What is lookup transformation?
wat are deployement groups in informatica, how it will be used for developers
complex mapping ur project u r invlve can u explain and give real time example give me ?
How to extract sap data using informatica? What is abap? What are idocs?
What is the function of aggregator transformation?
Differentiate between a database and data warehouse?
How might you approve all mappings in the archive all the while?