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 mapping debugger?
How can we handle two sessions in informatica?
What is meant by a domain?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Explain the features of connected and unconnected lookup.
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What is joiner transformation in informatica?
What is pmcmd command?
Explain how many types of dimensions are available in informatica?
What is the difference between stop and abort in informatica
I have a flat file, want to reverse the contents of the flat file
Which transformation is needed while using the Cobol sources as source definitions?
Explain the use of aggregator cache file?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What is the command used to run a batch?