Answer Posted / ankur saini

sol--seq gen---rank ---filter

add a sequence generator ...

ex input is
1 a
1 b
2 a
2 b
after seq generator
1 a 1
1 b 2
2 a 3
2 b 4

then ranl it group by all file ports rank on the seq gen key
input seq rank
1 a 1 1
1 b 2 2
2 a 3 1
2 b 4 2

add filter on rank=1

enjoy!!!!!

What are the measure objects?

1211

---

How many input parameters can exist in an unconnected lookup?

1550

---

Write the program through which the records can be updated?

1010

---

What is an aggregator transformation?

1100

---

Target increases every day even though no new record was inserted

1588

---

How does a sorter cache works?

1075

---

Is it possible to define a single node as a Gateway node as well as worker node?

1125

---

Under what condition selecting sorted input in aggregator may fail the session?

1127

---

What are the components of the workflow manager?

1138

---

What are the types of schemas we have in data warehouse and what are the difference between them?

946

---

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8227

---

What are Dimensional table?

1063

---

Partition, what happens if the specified key range is shorter and longer

2502

---

What is the surrogate key?

1271

---

On which transformations you created partitions in your project?

1349

---