Answer / parikhita prusty

MY dear friend when we used pushdown optimization it
increases the session performanse.

The integration service analyses mapping transformations and
determine which t?r logic to be sent to the target and
source database.

The integration servicetranslates the T/r logic into sql and
sends it into the database for processing.

The pushdown optimization is configured in 3 ways
i) Source side PDO
ii)Target side PDO
iii)Full side PDO(Both source and target side)

If anybody have some doubts u can ask in my mail id
parikhita2000@gmail.com

Regards
Parikhita

Answer / priyank

Hi,

For Pushdown optimization, we use

1. Temporary View for the below scenarios:
a. When the SQ or look up t/f contain a SQL override.
b. When the look up t/f is used with Filter t/f.
c. When an unconnected look up is used.

2. Temporary Sequence is used for the below scenario:
a. When a Sequence generator t.f is used in the mapping.


When Source side PDO is selected, the IS traverses from
Source side to the Target side till it comes across a
transformation whose logic cannot be pushed to the
database. If the logic for all the transformations can be
pushed to the database, still the target update override
query will be executed on the target database as logic of
transformations are pushed to the database whcih includes
the SQ query.

As per me, the push down optimizations are mainly used for
performance enhancement of the workflows as there are some
logics which can be exected faster on the database compared
to Informatica.

Please let me know all your comments if any on the above.

Answer / manojkumar

Thanks you so much parikhita.

Can you give me the exact two options(use view,..) which
will enabled when we select pod and how these options will
work?

When I select pod on source side, what about target insert
or update query ? will it be pushed to target db? Or only
select query will be pushed to source db ?

and when do we need to go for pushdown optimization
technique ? ofcourse it increses the performance. But at
what situation or circumstances we need to go for pod ?

If informatica has its scheduler why using third party scheduler?

0 Answers  

---

can we use cartesian join in informatica

3 Answers   IBM,

---

Using Connected or unconnected lookup for performance wise which one is preferable?.

1 Answers   Deloitte,

---

how many data models u have done in informatica project?

2 Answers   TCS,

---

how to join the two flatfiles using the joiner t/r if there is no matching port?

5 Answers   Cegedim,

---

we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks

3 Answers   TCS,

---

How many number of sessions that u can create in a batch?

3 Answers  

---

my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my target should be ABC 1 2 3, XYZ 4

2 Answers   Zensar,

---

How can i explain my project architecture in interview..? in Igate asked me tell me your project flow from source to target..?

1 Answers   Ameri Group, CGI, CTS, HCL, iGate, TCS, Wipro,

---

If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?

1 Answers   TCS,

---

How many ways are there to create ports?

0 Answers   Informatica,

---

i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table: pls full details

8 Answers   L&T, TCS, UnitedHealth Group, Wipro,

---