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

What is workflow? What are the components of workflow manager?

1133

---

What is meant by active and passive transformation?

1061

---

Define mapping and session?

990

---

How to do the error handling of if ur source is flatfiles?

1929

---

Explain about Informatica server process that how it works relates to mapping variables?

1027

---

What are the new features of Power Center 5.0?

1720

---

What is decode in static cache?

1109

---

What is xml source qualifier transformation in informatica?

1186

---

What is the status code in stored procedure transformation?

1138

---

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2038

---

In development project what is the process to follow for an etl developer from day1

1671

---

What are the tasks that can be performed using sq?

1042

---

How to load the name of the current processing flat file along with the data into the target using informatica mapping?

1194

---

hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

2048

---

what is SDLC way of code development?

1983

---