Answer Posted / sunil

To eliminate duplicates from flat file use sorter in that
select distict option...it will work

Can we change Dynamic to Static or Persistent cache? If so what happens?

2208

---

What all are steps in up gradation of Informatica server?

1043

---

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

2131

---

What is the maplet?

1118

---

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2322

---

What is sorter transformation?

1045

---

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

973

---

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

2393

---

What is meant by lookup transformation?

1101

---

What is a filter transformation and why it is an active one?

968

---

What are the steps involved in the migration from older version to newer version of Informatica Server?

2105

---

What are the guidelines to be followed while using union transformation?

1141

---

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1120

---

What is an active transformation?

1098

---

Explain the difference between mapping parameter and mapping variable?

1033

---