Answer Posted / gagan

We can use expression transformation and in expression
transformation we can compare previous records and current
records and if previous record matches the current record
then we can keep a value as 'Reject' for a variable port
and otherwise null.
After that by applying filter tansformation we can remove
all records which have column value as 'Reject'

This will remove duplicate values.

What are the different ways to implement parallel processing in informatica?

1423

---

What are the features of complex mapping?

1152

---

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2118

---

What is Data Caches size?

1086

---

Explain what are the different types of transformation available in informatica.

1139

---

Make a note of the quantity vaults made in informatica?

988

---

How to update a particular record in target with out running whole workflow?

1575

---

Why update strategy and union transformations are active? Explain with examples.

1238

---

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

1037

---

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

10164

---

What is blocking transformation?

1140

---

Under which circumstances, informatica server creates reject files?

1086

---

How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1625

---

What is a repository manager?

1087

---

What are the differences between a connected lookup and unconnected lookup?

1068

---