where actually the usage of push down optimization
happens...
- 2 Answers
- 4786 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / krish
One can push transformation logic to the source or target
database using pushdown optimization. The Integration
Service translates the transformation logic into SQL queries
and sends the SQL queries to the source or the target
database which executes the SQL queries to process the
transformations. The amount of transformation logic one can
push to the database depends on the database, transformation
logic, and mapping and session configuration. The
Integration Service analyzes the transformation logic it can
push to the database and executes the SQL statement
generated against the source or target tables, and it
processes any transformation logic that it cannot push to
the databas
there are some limitations to it like if we are using
variable port we can't do pushdown.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / pradeep
Basically we use the push down optimization to reduce the load on the integration service.The integration service translate the business logic into sql query and it pushes to source & Target dbs.In this form we can reduce the load on integration.
| Is This Answer Correct ? | 1 Yes | 0 No |
explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???
Write the unconnected lookup syntax and how to return more than one column.
Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?
What are the types of maping in Getting Started Wizard?
How to load a Dimension ? and how to load a fact table?
how to obtain performance data for individual transformations.
What is a predefined event?
how we do performence tuning in informatica
My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following EmpID, Salary, Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103, 3000, 6000). Please guide on how to build the mapping.
Differences between version 7.x and 8.x.
0 Answers Accenture, Cognizant,
What does “tail –f” command do and what is its use as an Informatica admin.
What is parallel processing in informatica?
Teradata 
