tell me the push down optimization

Answers were Sorted based on User's Feedback



tell me the push down optimization..

Answer / nagaraju

push down optimization is used increase the performance.in this concept integration service convert the transformation logic into query and send to the database.

Is This Answer Correct ?    0 Yes 0 No

tell me the push down optimization..

Answer / akhil4

this option available in session(work flow) properties.
it increase informatica server performance.
when ever u enable this option it created view in database related to logic.(MEANS YOU TAKEN SEVERAL T/R IN THIS U HAVE IMPLEMENTED LOGIC USING THAT LOGIC IT WILL CREATE A VIEW)
U START WF IT TAKE THE DATA DIRECTLY TO SQ AND PUSH DATA THROUGH LOGIC AND LODES INTO TARGET.

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More Informatica Interview Questions

what is a time dimension? give an example?

2 Answers   IBM,


what is the logic will you implement to load data into a fact table from n dimension tables?

4 Answers   TCS,


write sql query to filter the null value data following table? name age john 30 smith null null 34 sharp 24 i want the output following are name age john 30 sharp 24

2 Answers   HP,


1:when we develop a project what are the performance issue will raise?? KPIT 2:if a table have INDEX and CONSTRAINT why it raise the performance issue bcoz when we drop the index and disable the constraint it performed better??KPIT 3:what are unix commands frequently used in informatica??

1 Answers   KPIT,


How can we improve session performance in aggregator transformation?

0 Answers   Informatica,






What is a diff between joiner and lookup transformation

16 Answers   CTS, Satyam, TCS, UHG,


Where we use dynamic lookup and where we use it?do we generate surrogate keys using dynamic lookup?can we use it for scd type 2 mapping and why?

3 Answers   Amdocs,


Hi I'm new in Informatica. Can you show me a mapping sample on how to piviot the records? Thanks Robin

1 Answers  


how can we load starting with 11th record of a table from source to target

6 Answers   IBM,


how the server recognises , if the session fails after loading the 100 records in to the target

2 Answers   TCS,


How is Data Models Used in Practice?

1 Answers  


What is the function of aggregator transformation?

0 Answers  


Categories