What is the exact difference b/w IN and EXIST in Oracle..?
- 4 Answers
- 8097 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 different clients of powercenter?
What are the mapping parameters and mapping variables?
What is an Integration service in Informatica?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What is decode in static cache?
What is the Process to creating lookup transformation in informatica
What are the types of caches in lookup? Explain them.
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
Explain sql transformation in script mode examples in informatica
Why union transformation is an active transformation?
How can we remove the duplicates from flat file source?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
What is workflow manager?
What are the restrictions of union transformation?
Explain lookup transformation is active in informatica
