Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

Any one can tell me how to explain puss-down optimization ?
explain me with example plz?

Question Posted / babu

Answer Posted / 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.

Is This Answer Correct ?    9 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Mention some types of transformation?

1094

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1962

How many number of sessions can one group in batches?

1215

What is sq transformation?

1229

how tokens will generate?

2247

How are the sources and targets definitions imported in informatica designer?

1170

Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1723

What are the different versions of informatica?

1332

Explian the Process of deployment groups in informatica

1102

What is lookup transformation?

1092

How to generate sequence numbers without using the sequence generator transformation?

1254

list out all the transformations which use cache?

1239

Design a mapping to load the cumulative sum of salaries of employees into target table?

1554

What is rank index in rank transformation?

1126

Design time, run time. If you don't create parameter what will happen

1892