Answer Posted / naresh araveti

source> dynamic lookup>router,2 conditions 1. condition
if column_lkp port is null then insert into target1(unqie)
2. condtion if COLumn_lkp port is not null then insert into
target2(duplicates)

How to generate sequence numbers without using the sequence generator transformation?

1200

---

How many dimensions are there in informatica?

1073

---

How to create Target definition for flat files?

1211

---

What are the differences between oltp and olap?

969

---

What is intricate mapping?

1190

---

What is DR strategy for Informatica project?

1166

---

What are roles and groups and benefits of using them?

1052

---

What is a connected transformation?

1112

---

What are the conditions needed to improve the performance of informatica aggregator transformation?

1086

---

Differentiate between joiner and lookup transformation?

1100

---

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1620

---

Explain about cumulative Sum or moving sum?

1035

---

What is difference between a gateway node and worker node?

1129

---

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1039

---

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2389

---