Answer Posted / jz

If Two Flat files having same coll then go for Union t/r to
join.

Is stop and abort are same in informatica?

1002

---

Why is sorter an active transformation?

1129

---

Define update strategy?

1230

---

Differentiate between reusable transformation and mapplet.

1096

---

Explain dynamic target flat file name generation in informatica

1055

---

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?

10170

---

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1105

---

How to implement security measures using repository manager?

1178

---

What does update strategy mean, and what are the different option of it?

1092

---

What is the meaning of decode in informatica?

1122

---

How to load the data from a flat file into the target where the source flat file name changes daily?

1063

---

What are the measure objects?

1203

---

While migrating the data from one environment to another environment how would you manage the connections?

1090

---

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

1050

---

What is the need of an ETL tool?

1101

---