Interested to Buy Any Domain ? << Click Here >> for more details...
where actually the usage of push down optimization
happens...
- 2 Answers
- 5519 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 |
how to find the 5th highest salary form each department using 1.SQL Query 2. Informatica power center designer?
What is the function of aggregator transformation?
What are the tasks that can be performed using sq?
How do you change a non-reusable transformation to reusable transformation?
in which situations do u go for sequence generator ?
i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What is surrogate key?
there is a comma separated flat file as source and there is a column in that one field is having space like "rama krishna" like that what happens when this is used as source
split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar
1 Answers Cap Gemini, TCS, Wipro,
Want to know about Training Centres for Informatica, Cognos and ETL Softwares in Mumbai, India.
Teradata 
