Interested to Buy Any Domain ? << Click Here >> for more details...
explain different levels in pushdown optimization with example?
- 2 Answers
- 7265 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 |
Where is metadata stored?
What is Collect performance data in informatica and what is the use of it.
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1 from dual? what is the out put of the above queries?
What are the different ways to implement parallel processing in informatica?
Is it possible to create multiple domains on a single Informatica server?
Issue with Update override at Target table in Informatica.
create a mapping to retrieve the employees who are getting salary greater than average salary?
How union transformation is used?
How you can differentiate between connected lookup and unconnected lookup?
in oracle write query yourname+1 from dual
i have a source of n records.i have to load n+5 records to my target.What is the procedure??????plz tell me.....
Teradata 
