Interested to Buy Any Domain ? << Click Here >> for more details...
What is the exact difference b/w IN and EXIST in Oracle..?
- 4 Answers
- 9420 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 is exclusive and normal mode for repository services?
How can repository reports be accessed without sql or other transformations?
What are the different transaction levels available in transaction control transformation?
If informatica has its scheduler why using third party scheduler?
what is the complex transformation you used in informatica
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Define enterprise data warehousing?
in reporting we add some new objects,how we get the count of the newly added objects to the report
What is blocking transformation?
What is flashback table ? Advance thanks
What is decode in informatica?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
COM components can be used in Informatica
During the running session, output files are created by informatica server. Enlist few of them.
