Interested to Buy Any Domain ? << Click Here >> for more details...
What is the exact difference b/w IN and EXIST in Oracle..?
- 4 Answers
- 9066 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 do you mean by enterprise data warehousing?
difference between informatica 8.1.1 and 8.6
How to join three sources using joiner?
How to generate sequence numbers without using the sequence generator transformation?
How is union transformation utilized?
How do we call shell scripts from informatica?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
wf dont have integration severances how you can run?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
what is Active lock explain
Write the unconnected lookup syntax and how to return more than one column.
Can u generate reports in Informatica?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What is session task and command task?
Explain the use of aggregator cache file?
