where actually the usage of push down optimization
happens...
- 2 Answers
- 4787 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain Dataware house architecture .how data flow from intial to end?
How to update or delete the rows in a target, which do not have key fields?
is it possible to index the data in cache of lkp transformation ?
What is sq transformation?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Explain joiner transformation in informatica
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
what is size of u r database?
What is target designer and target load order?
How many dimensions are there in informatica?
Explain the different lookup methods used in informatica?
How do you manage the Parameter files while migrating your data from one environment to another environment?
How do you use reject loader.
How to extract the informatica rejected data?
what is the difference between informatica6.1 and infomatica7.1
