What is the exact difference b/w IN and EXIST in Oracle..?
- 4 Answers
- 8364 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 are the restrictions of union transformation?
can we override a native sql query within informatica? How do we do it?
If informatica has its scheduler why using third party scheduler?
How can we update a record in the target table without using update strategy?
In development project what is the process to follow for an etl developer from day1
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
What are the modules in Power Center
What is a filter transformation and why it is an active one?
Explain the different kinds of facts.
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
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
What are the data movement modes in informatica?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Explain the mapping variable usage example in informatica
What do you understand by a term domain?
