Interested to Buy Any Domain ? << Click Here >> for more details...
explain different levels in pushdown optimization with example?
- 2 Answers
- 7370 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 |
How do you take back up of repository?
Name 4 output files that informatica server creates during session running?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
how to import multiple flat files in to single target where there is no common column in the flat files
I have a scenario with lookup table. in that lookup table have colomns, but i need to process only 10 colomns out of 50. Please te me how can we acheive it?
Define sessions in informatica etl?
How do you promote a non-reusable transformation to reusable transformation?
How will you check the bottle necks in informatica? From where do you start checking?
supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How
What are the designer tools for creating tranformations?
If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?
How to do unit testing in informatica?
Teradata 
