Answer Posted / sanjay

here i m taking the example of employee table

first use the sorter to get the distinct value....

then use the agg trns, create the output port and use the
count function on employee_id to get the total no. of rows
like.. count(employee_id) and group by employee_id.

create filter trns.. write a condition where output>1... map
it with the target...

design of staging area?

2075

---

How can a transformation be made reusable?

1223

---

Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

2346

---

What is a repository? And how to add it in an informatica client?

1192

---

What is exclusive and normal mode for repository services?

1189

---

Where do we use mapping variables in informatica?

1118

---

lookup transformation with screenshots

4046

---

How many number of sessions can one group in batches?

1215

---

what is INFORMATICA TESTING process

2331

---

in reporting we add some new objects,how we get the count of the newly added objects to the report

2249

---

Can you use flat files in Mapplets.

2710

---

Can we create two repositories on same database instance in oracle?

1135

---

where to store informatica rejected data? How to extract the informatica rejected data?

1053

---

How do you update the records with or without using update strategy?

1160

---

Suppose we do not group by on any ports of the aggregator what will be the output?

1096

---