Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between IN and Exists in Oracle?
- 4 Answers
- 18298 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / sri
when the condition is in a subquery then in will be used
where if there is a condition in superquery
(parent) exists will be used. Usage of IN will improve the
performance
| Is This Answer Correct ? | 0 Yes | 10 No |
Post New Answer View All Answers
What are the different types of repositories created using informatica?
What is lookup change?
What is transformation?
How does a sorter cache works?
Performance tuning( what you did in performance tuning)
What is mapping debugger?
Define the various join types of joiner transformation?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is the procedure for creating independent data marts from informatica 7.1?
What is sequence generator transformation in informatica?
Explain the scenario which compels informatica server to reject files?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
