Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between IN and Exists in Oracle?
- 4 Answers
- 18299 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / ram
exists improves the performance because it returns boolian
value where as 'in' is not...so exists simplyfies internal
calculations....
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
How do you load only null records into target? Explain through mapping flow.
How to update a particular record in target with out running whole workflow?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How do you load only null records into target?
Define update strategy?
4 yrs etl devloper roles and responsibilities?any body give solutions
What is informatica? Why do we need it?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is workflow? What are the components of the workflow manager?
Explain the mapping variable usage example in informatica
What are the new features of Power Center 5.0?
Is it possible to revert a global repository to local one and why?
What are the different lookup cache(s)?
What is rank transformation in informatica
COM components can be used in Informatica
