Answer Posted / 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

How can we handle two sessions in informatica?

1027

---

Explain pushdown optimization $pushdownconfig parameter - informatica

1122

---

What is the function of aggregator transformation?

1078

---

EXL informatica Questions

1382

---

What is rank transformation?

985

---

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

6474

---

Performance tuning( what you did in performance tuning)

1972

---

Explain dynamic target flat file name generation in informatica

1044

---

How many input parameters can exist in an unconnected lookup?

1540

---

What is the difference between STOP and ABORT options in Workflow Monitor?

1253

---

How to implement security measures using repository manager?

1168

---

What is the Process to creating lookup transformation in informatica

1038

---

What is a pre-defined event and user-defined event?

1035

---

Define joiner transformation?

1045

---

As union transformation gives UNION ALL output, how you will get the UNION output?

1106

---