Answer Posted / akash

In addition to the above answers I will add one more option.

We can use expression to check whether a record is
repeating or not and set an output port as flag. For first
occurence of any record this flag is 1. Use router after
this with condition "i_FLAG = 1". This output will give
only unique records. Default output will give only
duplicate records.

Also we can use a filter after the above expression with
the condition "i_FLAG = 1"

Differentiate between a repository server and a powerhouse?

1113

---

How to update source definition?

1082

---

Explain informatica architecture - version 8 / 9

1081

---

What is the benefit of partitioning a session?

1169

---

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.

2300

---

permutations of mapplet

2504

---

tell me about your project functionality

2339

---

What is status code in informatica?

1009

---

Write the prerequisite tasks to achieve the session partition?

1145

---

Explain how many types of dimensions are available in informatica?

1088

---

Make a note of the quantity vaults made in informatica?

983

---

Where do we use mapping variables in informatica?

1059

---

How you prepared reports for OLAP?

1593

---

What is a sorter transformation?

1093

---

Is it possible to revert a global repository to local one and why?

1073

---