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 tasks that source qualifier perform?
Sequence generator, when you move from develoment to production how will you reset
Explain Dataware house architecture .how data flow from intial to end?
Differentiate between a repository server and a powerhouse?
what is Active lock explain
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What is the difference between router and filter?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
Enterprise data warehouse your projects phase by phase explain?
Plz can any one say me how to get the informatica certification materials and dumps
Can we create two repositories on same database instance in oracle?
What is the format of informatica objects in a repository?
What differs when we choose the sorted input for aggregator transformation?
What all join we can perform in LOOKUP transformation?