Any one can tell me how to explain puss-down optimization ?
explain me with example plz?
- 1 Answers
- 4150 Views
- I also Faced
- E-Mail Answers
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.
| Is This Answer Correct ? | 9 Yes | 0 No |
What are the different caches used in informatica?
what is constraint based load order
How to Join Tables my Source is having 15 table target is one?
Tell me about MD5 functions in informatica
What is the "File Repository" and how can we use that in the Informatica ? Please give one example of the Process ? waiting for Reply... Thank you .
How do you load only null records into target? Explain through mapping flow.
how many types of dimensions are available in informatica?
What is mapplet and a reusable transformation?
how to load only the first and last record of a flat file into the target?
What is data quality? How can a data quality solution be implemented into my informatica transformations, even internationally?
How to recover sessions in concurrent batches?
what is mapping parameter and mapping variables
Teradata 
