Interested to Buy Any Domain ? << Click Here >> for more details...
What is the exact difference b/w IN and EXIST in Oracle..?
- 4 Answers
- 9223 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / pavan_615
IN- sub Query - it will be executed once for the full query
Exist - Co-related sub Query - it will be executed for each
row.-- exist will me faster when you are working with big
tables.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the types of caches in lookup? Explain them.
Explain your project of banking domian.
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What is the meaning of up gradation of repository?
What is the use of an aggregator cache file?
what is Active lock explain
What is the fact table?
Enlist some properties of sessions.
How to do the error handling of if ur source is flatfiles?
How many numbers of sessions can one group in batches?
What is persistent lookup cache?
What are the designer tools for creating transformations?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
EXL informatica Questions
