What is the difference between a router and a filter transformation?

1 Answers   TCS,

---

if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20000,30000,40000 ex-output eno totsal 1 30000 2 50000 3 70000

7 Answers  

---

My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?

3 Answers   Span Systems,

---

What is CHECK-IN CHECK-OUT. Please explane me?

3 Answers   TCS,

---

What is Session and Batches?

0 Answers   Informatica,

---

without matching columns in two tables. how can you join

5 Answers   BirlaSoft,

---

How can you increase the performance in joiner transformation?

0 Answers  

---

If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks

7 Answers   Puma,

---

how to duplicates from expression transformation without using sorter before that

1 Answers  

---

WHat all joins are there in Source Qualifier?

1 Answers  

---

How could we generate the sequence of key values without using sequence generator transformation in the target ??

12 Answers   TCS, Tech Mahindra,

---

Enlist the various types of transformations.

0 Answers  

---