Interested to Buy Any Domain ? << Click Here >> for more details...
explain different levels in pushdown optimization with example?
- 2 Answers
- 7281 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
1. Source side push down
Integration service determine the T/r logic it ll send
as much as possible to source data base server
2.Target side push down
Integration service determine the T/r logic it ll send
as much as possible to targer data base server
3.fullside push down
Integration service determine the T/r logic it ll send
to source and target data base server
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / praveen hattikal
pushdown optimization: way of load balancing among the
servers to achieve optimal performance
Veteran ETL developers often come across issues when they
need to determine the appropriate place to perform ETL
logic. Suppose an ETL logic needs to filter out data based
on some condition. One can either do it in database by
using WHERE condition in the SQL query or inside
Informatica by using Informatica Filter transformation.
Sometimes, we can even "push" some transformation logic to
the target database instead of doing it in the source side
(Especially in the case of EL-T rather than ETL). Such
optimization is crucial for overall ETL performance.
| Is This Answer Correct ? | 0 Yes | 0 No |
list out all the transformations which use cache?
difference between informatica 8.6 and 9
3 Answers Atos Origin, BA Continnum Solutions, Core Logic,
how to join two flat files in informatica?
What is parallel processing in informatica?
How to convert IBM Cognos generated XML to a readable XML format for ETL tools
Create a mapping which contains 2 target tables. When the session runs for the first time it shud load Target table 1 and when it runs for second time it shud load Target table 2.
How to elaborate tracing level?
what is the diff b/w cached and unchaed look ups
How i can Schdule the Informatica job in "Unix Corn Schduling tool" ?
In a table, 4 person having same salary. How to get Third person record only?
State the limitations where we cannot use joiner in the mapping pipeline?
Diffrence between 7.1,8.1 and 8.6
Teradata 
