Answer Posted / pankaj

In sql server,

WHEN YOU USE 'IN', WHILE CHECKING FOR WHERE CONDITION SQL SERVER ENGINE DOES WHOLE TABLE SCAN. IF YOU USE 'EXISTS' AS SOON AS ENGINE FINDS THE REQUIRED ROW IT WILL STOP EXECUTING QUERY AND GOING FURTHER SCANNING TABLE.

In Oracle,
EXISTS is very faster than IN (when the subquery results is very large)

IN is faster than EXISTS (when the subquery results is very small)

In Example -
select ename from emp
where mgr in (select empno from emp where ename = 'KING');

Exists Example -
Select ename from emp a where exists ( select 0/null from emp b where a.mgr=b.empno and ename='KING')

What are the different types of repositories created using informatica?

1140

---

What is the sequence generator transformation in informatica?

1184

---

what is the size of your data warehousing?

2095

---

is it possible to index the data in cache of lkp transformation ?

2029

---

Can we create a node as a gateway node and the same node can be assigned to a grid?

1079

---

Differentiate between source qualifier and filter transformation?

1578

---

What is Index Caches size?

1116

---

explain one complex mapping with logic? sales project?

6670

---

What is meant by lookup transformation? Explain the types of lookup transformation?

952

---

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

2171

---

Target increases every day even though no new record was inserted

1580

---

What is lookup change?

1048

---

What is a grid in Informatica?

1071

---

What are the various types of transformation?

1179

---

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2456

---