By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? which transformation we need to use?

8 Answers  

---

HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in the expression transformation and the aggregator transformation. But, what exactly I want is .. If we have million of records,it is not possible using decode and search for that Particular Id to pivot into Horizontal data... Can any one of guys please help me in this regard.....

3 Answers   TCS,

---

in aggregator transformation we want to get middle record how to implement, source containg empno,name sal,deptno,address

1 Answers   Cognizant,

---

How to retrieve last two days updated records?

4 Answers  

---

how to duplicates from expression transformation without using sorter before that

1 Answers  

---

scenario where i can use only concurrent execution of workflow.

0 Answers   Cognizant,

---

How will you display "Mr" for male & "Mrs" for female in target table?

7 Answers  

---

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

0 Answers  

---

Write the different tools in the workflow manager?

0 Answers  

---

What is A complex mapping?

3 Answers   TCS,

---

What are the types of presistent cache in look up tr.

0 Answers   IBM,

---

i want to convert below src into target src is as follows maths 30 science 20 social 81 i want data in trg like below maths science social 30 20 81

2 Answers   HCL, HP,

---