Answer Posted / thava

Pipeline term in informatica means the way source is flow
to target via any transformation e.g filter transformation

How do you load first and last records into target table?

1159

---

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6182

---

How to go to the older version for a mapping?

1100

---

Differentiate between a repository server and a powerhouse?

1119

---

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

1576

---

What if the source is a flat-file?

1112

---

What are multi-group transformations?

1103

---

Performance tuning( what you did in performance tuning)

1988

---

What are data-driven sessions?

1213

---

What is a rank transform?

1086

---

what is the Default Source Option For Update Strategy Transformation?

1241

---

Explain direct and indirect flat file loading (source file type) - informatica

1318

---

Where is metadata stored?

1113

---

How many ways a relational source definition can be updated and what are they?

1018

---

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

2211

---