Answer / lahari

There are multiple ways to do it.
1.if source is RDBMS then we can filter by selecting distinct option.
2.In sorter transformation select distinct.
3.In Aggregator transformation select all ports as group by key.

How many numbers of sessions can one group in batches?

0 Answers  

---

What are the tasks that Loadmanger process will do?

1 Answers  

---

Explain pmcmd command usage in informatica

0 Answers   Informatica,

---

What is the scenario which compels informatica server to reject files?

0 Answers  

---

which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..

7 Answers   TCS,

---

Hi experts, can anyone tell how much we use plsql in real time

3 Answers  

---

There are 100 lines in a file. How to print line number 31-50 and 81-90 in unix with a single command.

2 Answers   L&T,

---

What are different types of transformations available in informatica?

0 Answers  

---

how to return multiple columes through through un-connect lookup?

1 Answers   DELL,

---

4 yrs etl devloper roles and responsibilities?any body give solutions

0 Answers   TCS,

---

IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????

3 Answers   IBM,

---

we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?

2 Answers   Patni, Tech Mahindra,

---