suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping?how

4 Answers   CTS,

---

hi all hi have flat file like below my requirement is empid,ename,sal,loc 101,vamshi,5000,hyd 101,vamshi,5020,hyd 201,raju,5000,hyd 202,ram,4000,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd i want the o/p like this in one target 201,raju,5000,hyd 202,ram,4000,hyd and in second target 101,vamshi,5000,hyd 101,vamshi,5020,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd

9 Answers   IBM,

---

empno sal 1 8000 2 9000 3 8000 4 1000 how to get highest sal wise rankings in rank t/r.

3 Answers  

---

What is the main difference between a Joiner Transformation and Union Transformation?

5 Answers  

---

What are the reusable transformations?

0 Answers   Informatica,

---

Mention few power centre client applications with their basic purpose?

0 Answers  

---

what is curr val use for in sequence generator?

2 Answers   Emphasis,

---

In mapping f.f as one src and f.f as trg,f.f as src and oracle as trg which is fast? mean which is complete first process

2 Answers   Wipro,

---

What is olap (on-line analytical processing?

0 Answers  

---

Could any one to tell Fact table Partitioning?

2 Answers  

---

When do you use sql override in a lookup transformation?

0 Answers  

---

In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query

8 Answers   Cap Gemini,

---