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.

How might one distinguish in the case of mapping is right or not without associating session?

1018

---

Quickly characterize reusable change?

1057

---

What are the tuning techniques you applied during your last project

1963

---

Explain transaction control transformation in informatica

1209

---

What is an unconnected transformation?

1032

---

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2506

---

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

1048

---

How do you manage the Parameter files while migrating your data from one environment to another environment?

960

---

Informatica settings are available in which file?

935

---

What are the reusable transformations?

1094

---

What is a transaction control transformation?

1140

---

What is aggregate cache in aggregator transformation?

1057

---

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5677

---

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

2116

---

What do you understand by a term domain?

1060

---