Answer / venkateshmalneni

EXIST is used as conditional operator in which u can write a query
IN is also used as a conditional operator in which we gives a list of elements

Answer / moorthy g

select ename from emp e
where mgr in (select empno from emp whereename = 'KING');

Here's the EXPLAIN PLAN for this query:

OBJECT OPERATION
---------- ----------------------------------------
SELECTSTATEMENT()
NESTEDLOOPS()
EMP TABLEACCESS(FULL)
EMP TABLEACCESS(BY INDEX ROWID)
PK_EMP INDEX(UNIQUESCAN)

This query is virtually equivalent to this:

select e1.ename from emp e1,(select empno from empwhere
ename = 'KING') e2
where e1.mgr = e2.empno;

You can write the same query using EXISTS bymoving the outer
query column to a subquery condition, likethis:

select ename from emp e
where exists (select 0 from emp wheree.mgr = empno and
ename = 'KING');

When you write EXISTS in a where clause, you'retelling the
optimizer that you want the outer query to be runfirst,
using each value to fetch a value from the inner
query(think: EXISTS = outside to inside).

Answer / 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

Answer / 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.

What aer the out put files that the informatica server creates during the session running?

4 Answers  

---

What is limitations of truncate and load option

1 Answers   Cap Gemini,

---

what is dynamic cashe

3 Answers   Informatica,

---

Clarify the aggregator change?

0 Answers  

---

Differentiate between a repository server and a powerhouse?

0 Answers  

---

how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

0 Answers   Patni,

---

can we import source table without using source qualifier? if yes then how? if no then why?

2 Answers   Thomson Reuters,

---

performance wise which one is better in joiner and lookup transformation?why?explain clearly?

4 Answers   IBM,

---

What is meta data and system catalog?

2 Answers  

---

How to recover the standalone session?

2 Answers  

---

Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?

5 Answers  

---

how to get the only updated records in the target

2 Answers  

---