Interested to Buy Any Domain ? << Click Here >> for more details...
where actually the usage of push down optimization
happens...
- 2 Answers
- 5607 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain scd type 3 through mapping.
How union transformation is used?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Whats the difference between informatica powercenter server, repositoryserver and repository?
What is the use of transformation?
What are batches?
How to load a Dimension ? and how to load a fact table?
lookup transformation with screenshots
Under what conditions selecting sorted input in aggregator will still not boost session performance?
How to improve the performance of a session using sorter transformation?
what is the size of your data warehousing?
What is informatica metadata and where is it stored?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What the difference is between a database, a data warehouse and a data mart?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
