Answer Posted / venubyna1

1. Source side push down
Integration service determine the T/r logic it ll send
as much as possible to source data base server

2.Target side push down
Integration service determine the T/r logic it ll send
as much as possible to targer data base server

3.fullside push down
Integration service determine the T/r logic it ll send
to source and target data base server

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

1014

---

Clarify the utilization of aggregator cache record?

945

---

How can you validate all mappings in the repository simultaneously?

1289

---

Explain the difference between mapping parameter and mapping variable?

982

---

Define joiner transformation?

989

---

What are the types of presistent cache in look up tr.

2009

---

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1928

---

Under what conditions selecting sorted input in aggregator will still not boost session performance?

1026

---

What are active and passive transformations?

1022

---

Clarify the aggregator change?

972

---

COM components can be used in Informatica

2315

---

Explain in detail scd type 2 through mapping.

991

---

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

1535

---

what is the difference between informatica6.1 and infomatica7.1

2186

---

lookup transformation with screenshots

3941

---