Interested to Buy Any Domain ? << Click Here >> for more details...
where actually the usage of push down optimization
happens...
- 2 Answers
- 5514 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
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
In which transformation you cannot drag ports into it?
Can we get 1st record through Informatica(without sequence number).
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Can we create two repositories on same database instance in oracle?
CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks
Different circumstance which drives informatica server to expel records?
Explain transaction control transformation in informatica
What do think which one is the better joiner or look up?
What are the uses of etl tools?
How many numbers of sessions can one group in batches?
What are the issues you have faced in your project? How did you overcome those issues?
Name the different lookup cache(s)?
According to his methodology what all you need before you build a datawarehouse
What are the modules in Power Center
