![]() This generated statement will execute on source database and fetch the records and process further to insert/update/delete in target database. When we run a session configured for source-side Pushdown optimization, the Integration Service analyses the mapping from the source to the target direction and generate SQL SELECT statement as per the mapping logic. SQ_ITEMS – Source Qualifier transformationĮXP_Prices_Rankes – Expression Transformation Let us take below mapping example to understand deference between types. There are 3 type of Pushdown optimization available as mentioned below. Here whatever transformation logic can be convert in SQL query those can be push down on database side (execute on database). Pushdown Optimization is a concept of push Informatica transformation logic on source or target when they are database table. Pushdown optimization working on same concept. ![]() Always processing data on database level is faster than processing data in Informatica level. Pushdown Optimization is use to increase data processing performance extremely. ![]() Informatica ETL Developer | SQL Developer | IICS Developer | IDQ Developer We will see how to implement Pushdown optimization and its limitation. This article will help you to understand Pushdown Optimization technique to enhance Informatica ETL performance. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2024
Categories |