Answer Posted / infa_geek

Integration Service follows instructions coded into Update
Strategy and Custom transformations within the session
mapping to determine how to flag rows for insert, delete,
update, or reject.
If the mapping for the session contains an Update Strategy
transformation, this field is marked Data Driven by
default.
If you do not choose Data Driven when a mapping contains an
Update Strategy or Custom transformation, the Workflow
Manager displays a warning.

What is the use of an aggregator cache file?

1199

---

What is session task and command task?

1291

---

How to elaborate powercenter integration service?

1131

---

How to update source definition?

1082

---

difference between informatica 8.1.1 and 8.6

3677

---

During the running session, output files are created by informatica server. Enlist few of them.

980

---

can we override a native sql query within informatica? How do we do it?

1126

---

What is the surrogate key?

1258

---

What are the tuning techniques you applied during your last project

2024

---

how to load dimension table and fact table. plz tell me the steps.

2094

---

Explain informatica architecture - version 8 / 9

1087

---

Briefly define reusable transformation?

1127

---

update strategy transformation in informatica

1064

---

Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

1289

---

How many ways are there to do 'remove duplicate records in informatica'?

1010

---