Answer / babu

Hi,

In informatica 8.6.0 has one most usefull feature i.e
is nothing but a PUSHDOWN OPTIMISATION.This is available in
session properties.whenever the client want beter
performance that time we use this feature.

basically pshdown optimisation classified into 3 seps.
1.Sourece side pushdown optimisation.
2.Target side pushdown optimisation.
3.Full based pushdown optimisation.

1.Sourece side pushdown optimisation::
It means topush the
busines logic into source database(RDBMS ONLY)as much as
Possible.It reducess the burden of the informatica server
to run the session.

2.Target side pushdown optimisation::
It means topush the
busines logic into Target database(RDBMS ONLY)as much as
Possible.It reducess the burden of the informatica server
to run the session.
3.Full based pushdown Optimisation::
It means topush the
busines logic into Source,Target database(RDBMS ONLY) and
Informatica as much as Possible.It reducess the burden of
the informatica server to run the
session.
NOTE: The above all are work only the RDBMS files only
only.

please correct me if any thing wrong.

how can one come to know wether the records loak into the target if we use update strategy

1 Answers   Wipro,

---

How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?

4 Answers  

---

i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time

3 Answers   iGate,

---

write asql query to filter improper date format? date 20-apr 11-mar-2010 30-may-2010 feb-2009 i want the output date 11-mar-2010 30-may-2010

2 Answers   Accenture,

---

My source table having some records ,i want load 1st record and last record into one target?

3 Answers   iGate,

---

If you want to create indexes after the load process which transformation you choose?

3 Answers   HCL,

---

What is critical mapping?

2 Answers  

---

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

0 Answers  

---

In update strategy t/r we had given dd_insert condition & in session we gave delete condition . Then what will happen? mapping will run ?

3 Answers   emc2,

---

can anyone explain me about retail domain project in informatica?

0 Answers   Zensar,

---

What is the use of incremental aggregation?

2 Answers  

---

What is the status code in stored procedure transformation?

0 Answers   Informatica,

---