Interested to Buy Any Domain ? << Click Here >> for more details...
What is the exact difference b/w IN and EXIST in Oracle..?
- 4 Answers
- 9284 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 option by which we can run all the sessions in a batch simultaneously?
What is flashback table ? Advance thanks
What does “tail –f” command do and what is its use as an Informatica admin.
Explain joiner transformation in informatica
According to his methodology what all you need before you build a datawarehouse
What is the procedure for creating independent data marts from informatica 7.1?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Can we change Dynamic to Static or Persistent cache? If so what happens?
Explain about Informatica server process that how it works relates to mapping variables?
Define update strategy?
Write the different tools in the workflow manager?
What is olap (on-line analytical processing?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What are the static cache and dynamic cache in informatica?
How do you load unique records into one target table and duplicate records into a different target table?
