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

Is it possible to create multiple domains on a single Informatica server?

1217

---

What does reusable transformation mean?

1115

---

How can repository reports be accessed without sql or other transformations?

1200

---

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2113

---

How can we improve session performance in aggregator transformation?

1089

---

What is rank index in rank transformation?

1055

---

Please let me know how to make Data masking in informatica..

1695

---

Explain sessions?

1027

---

How can you validate all mappings in the repository simultaneously?

1349

---

Is it possible to revert a global repository to local one and why?

1062

---

As union transformation gives UNION ALL output, how you will get the UNION output?

1085

---

What is decode in informatica?

1122

---

Mention a few design and development best practices for informatica?

976

---

What is target designer and target load order?

1088

---

Is stop and abort are same in informatica?

984

---