Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between IN and Exists in Oracle?
- 4 Answers
- 18269 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / sri
when the condition is in a subquery then in will be used
where if there is a condition in superquery
(parent) exists will be used. Usage of IN will improve the
performance
| Is This Answer Correct ? | 0 Yes | 10 No |
Post New Answer View All Answers
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
How to delete duplicate row using informatica?
Define joiner transformation?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
my source is junk data how will u remove that junk data by using unix please any one replay me
Write the unconnected lookup syntax and how to return more than one column.
what is diff b/t sorter t/r and agg have the option sorter property...
What are the different ways to implement parallel processing in informatica?
Clarify the aggregator change?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
update strategy transformation in informatica
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
is it possible to index the data in cache of lkp transformation ?
When do you use sql override in a lookup transformation?
