Interested to Buy Any Domain ? << Click Here >> for more details...
How we will implement Pushdown Optimization and Types in Informatica with better examples
- 4 Answers
- 14012 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sridhar,informatica developer
normally pushdown optimization is used for eliminating
bottlenecks from session and to increase the performance of
your session.
here t he integration service pushing the business logic to
the target or source or both.
pushdown optimization can do in 3 ways
1)source side
2)target side
3)full
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / sridhar,informatica developer
normally pushdown optimization is used for eliminating
bottlenecks from session and to increase the performance of
your session.
here t he integration service pushing the business logic to
the target or source or both.
pushdown optimization can do in 3 ways
1)source side
2)target side
3)full
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / nsatyabrat7
Push Down Optimisation normally used for performance issue.
to use it u have to buy a separate license along with Informatica. As Sridhar tld there are 3 different kind of Push down optimisation which can be configured in session properties level.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / abhinaw prakash
Just to add on the above points.We cannot decide which
transofrmation logic to send to the Database.The
integrations service decides which login to send to the
database to optimize the process.although we can see the
sql logic in the Pushdown priview and the messages and
warning attached to it.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Which is the t/r that builts only single cache memory?
write a query to follwoing table amount year quarter 254556 2003 first 546332 2003 second 129034 2003 third 490223 2003 fourth 165768 2004 first 265443 2004 second 510412 2004 third 435690 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 254556 546332 129034 490223 2004 165768 265443 510412 435690
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Consider two cases: (1) Power Center Server and Client on the same machine (2) Power Center Sever and Client on the different machines what is the basic difference in these two setups and which is recommended?
difference between informatica 8.1.1 and 8.6? And different betweeninformatica 7x and 8x?
tell me some dimension tables names in banking domain informatica project(dont tell like depends on project, tell me names of dimension and fact table names in your project)?
What is the difference between informatics 7x and 8x and what is latest version?
How to create or import flat file definition in to the warehouse designer?
what are the types of facts with Examples?
while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
Teradata 
