explain different levels in pushdown optimization with example?
- 2 Answers
- 6815 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 |
i have source in oracle 10g,oracle 8i how will u take the data from two sources
who is the best faculty for informatica in hyderabad ameerpet?
Which gives the more performance when compare to fixed width and delimited file ? and why?
in reporting we add some new objects,how we get the count of the newly added objects to the report
wht is full process of Information source to target just like stg to productuon and development
What is use of batch file in informatica? How many types of batch file in informatica?
How to load last n records of file into target table - informatica
Can u generate reports in Informatica?
how can we load 365 flat file to a single fact table (target) as a history load in single mapping?
Want to know about Training Centres for Informatica, Cognos and ETL Softwares in Mumbai, India.
hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 b 200 100 n 300 400 p 3000 100 a 100 600 x 6000 Now i want to load half of this data into one flat file and remaining in other flat file.like :- flat file 1 id name amt 100 a 100 200 b 200 100 n 300 ---------------------- ---------------------- flat file 2 id name amt 400 p 3000 100 a 100 600 x 6000 Plz reply me ASAP.
Enlist the advantages of informatica.
Teradata 
