Interested to Buy Any Domain ? << Click Here >> for more details...
Any one can tell me how to explain puss-down optimization ?
explain me with example plz?
- 1 Answers
- 4920 Views
- I also Faced
- E-Mail Answers
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
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Is it possible to create multiple domains on a single Informatica server?
How you can differentiate between connected lookup and unconnected lookup?
Explain the tuning lookup transformation - informatica
Different sorts of metadata that stores in the storage facility?
Why sorter is an active transformation?
whats the logic to load the lower level of granularity of data to fact table.
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
How many ways are there to create ports?
What is enterprise data warehousing?
What is a surrogate key?
what is diff b/t sorter t/r and agg have the option sorter property...
Please let me know how to make Data masking in informatica..
Why update strategy and union transformations are active?
