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
- 4884 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 |
Write the program through which the records can be updated?
which is better perfomancewise lookup or joiner and why?can anyone give example?
can we use bulk loading when we use look in mapping
What is the difference between warehouse key and surrogate key?
What is the fact table?
When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?
Mention few advantages of router transformation over filter transformation.
what is surrogate id ?
If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?
if i have a file having record sal=10000,and when use router with two groups having condition sal>5000 in one group,sal>7000 in other group.and if two groups connected to two targets.in which target sal=10000 will go?
9 Answers BirlaSoft, Genpact, L&T, Syntel,
Explain the difference between mapping parameter and mapping variable?
When we are using Dynamic Cache,which options we will select in session level?
Teradata 
