Answer / venkatesh

by using aggrigator transformation we can eliminate
duplicate records in informatica
The flow will be like this

source--->aggrigator----->target

in aggrigator group by all ports then the out put is only
unique records
connect it to the target
2)we can do it by sorter also in sorter if we enable select
distinct then it will gives unique row
3)if u r source is database then u can select distinct in
sourcequalifier it self

update strategy transformation in informatica

0 Answers   Informatica,

---

how we can add header and footer to flat files?

2 Answers   Tech Mahindra, Zensar,

---

Can you generate reports in Informatcia?

1 Answers  

---

Explain the features of connected and unconnected lookup.

0 Answers  

---

What is the sql query overwrite in source qualifier in informatica

0 Answers   Informatica,

---

Explain pushdown optimization $pushdownconfig parameter - informatica

0 Answers   Informatica,

---

How to recover the standalone session?

2 Answers  

---

What is the sequence generator transformation in informatica?

0 Answers  

---

get me output as if input is like 1 x o/p-->1 x,y,z 1 y 2 a,b 1 z 3 c 2 a 2 b 3 c

0 Answers   Infosys,

---

I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?

3 Answers  

---

What is the "File Repository" and how can we use that in the Informatica ? Please give one example of the Process ? waiting for Reply... Thank you .

4 Answers  

---

If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 10 201 10 301 10 and i am using router TR to loading these records into target.Then how many record'll be loaded into target???

5 Answers   Wipro,

---