What is the exact difference b/w IN and EXIST in Oracle..?
Answer Posted / sujeetha
It is almost similar to IN but the difference is that in
EXIST it will retrive the row atleast one row in the inner
query satisfies but in IN we can have manuy values
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Differentiate between reusable transformation and mapplet.
State the differences between sql override and lookup override?
What are some examples of informatica etl programs?
Define joiner transformation?
I have a flat file, want to reverse the contents of the flat file
How to delete duplicate row using informatica?
How might you approve all mappings in the archive all the while?
What can we do to improve the performance of informatica aggregator transformation?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What are the types of presistent cache in look up tr.
What are session parameters ? How do you set them?
How can we use mapping variables in informatica? Where do we use them?
What is the scenario which compels informatica server to reject files?
Have you worked with/created Parameter file
Can we create two repositories on same database instance in oracle?