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.

update strategy transformation in informatica

0 Answers   Informatica,

---

What if we sort the data in descending order instead of increasing order in sorter t/f and send the data in aggregator t/f is there any performance downfall? Please answer below. thank you.

4 Answers   JPMorgan Chase,

---

What is difference between partioning of relatonal target and partitioning of file targets?

2 Answers  

---

Can we write to_date(three arguments) ? Will it work ? Advance thanks

1 Answers   Puma,

---

What are differences between Informatica 7.1 and 6.1

3 Answers  

---

what is difference between COM & DCOM?

1 Answers   Satyam,

---

Can anyone please distinguish what is Inner join and Outer join

2 Answers   Wipro,

---

What does role playing dimension mean?

0 Answers  

---

Source Qualifier is an active t/r but there is no change of row count then y should we called it active t/r & Router , sorter some times no change in row count then Y we called its active t/r?

2 Answers  

---

Can we run session without using workflows?

5 Answers   TCS,

---

How do you change parameter when you move it from development to production.

1 Answers  

---

Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

4 Answers   IBM, Infotech,

---