Answer Posted / chandu

select distinct a.sal from emp a where 10>=(select
count(distinct b.sal from emp b where a.sal<=b.sal)order by
a.sal desc

Global and Local shortcuts. Advantages.

2034

---

tell me about your project functionality

2341

---

What are different types of transformations available in informatica?

992

---

How union transformation is used?

1006

---

What are the transformations that are not supported in mapplet?

1029

---

expain about the tune parameters?

2414

---

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

2365

---

wf dont have integration severances how you can run?

1938

---

How to use pmcmd utility command?

1032

---

How do you use reject loader.

2603

---

How do you migrate data from one environment to another?

1095

---

Mention some types of transformation?

1048

---

What do think which one is the better joiner or look up?

1203

---

What are the various types of transformation?

1179

---

Please let me know how to make encryption and decryption with example?

1900

---