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

Explain joiner transformation in informatica

0 Answers   Informatica,

---

In ur current projectu have done any performance tuning of mappings?

1 Answers  

---

which T/r we can use it mapping parmeter and mapping variable? and which one is reusable for any mapping mapping parmeter or mapping varibale?

3 Answers   Wipro,

---

During the running session, output files are created by informatica server. Enlist few of them.

0 Answers  

---

following table source name gender a1 male a2 female how to change 'male' to 'female' and 'female' to 'male'

2 Answers  

---

can anyone explain me about retail domain project in informatica?

0 Answers   Zensar,

---

Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?

3 Answers   TCS,

---

What are the types of lookup transformation?

0 Answers   Informatica,

---

1:when we develop a project what are the performance issue will raise?? KPIT 2:if a table have INDEX and CONSTRAINT why it raise the performance issue bcoz when we drop the index and disable the constraint it performed better??KPIT 3:what are unix commands frequently used in informatica??

1 Answers   KPIT,

---

Hi, I have one scenario.. i want to insert 4 times (Duplicate) a row in the target. Please help me . source row: abcabc Tgt table: abcabc abcabc abcabc abcabc

10 Answers   Cap Gemini, IBM,

---

What is xml source qualifier transformation in informatica?

0 Answers  

---

How to handle changing source file counts in a mapping?

3 Answers   Deloitte, TCS,

---