What is the difference between IN and Exists in Oracle?
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 is index?how it can work in informatica
What are ETL Tools?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What is the need of etl tools?
What is the difference between informatics 7x and 8x and what is latest version?
What is rank transformation in informatica
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
can anyone explain me about retail domain project in informatica?
How do you handle two sessions in Informatica
Explain the aggregator transformation?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is decode in static cache?
How can we remove the duplicates from flat file source?
What is target load order?
What is repository manager?