Interested to Buy Any Domain ? << Click Here >> for more details...
How we will implement Pushdown Optimization and Types in Informatica with better examples
- 4 Answers
- 13990 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / sridhar,informatica developer
normally pushdown optimization is used for eliminating
bottlenecks from session and to increase the performance of
your session.
here t he integration service pushing the business logic to
the target or source or both.
pushdown optimization can do in 3 ways
1)source side
2)target side
3)full
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
How do you take back up of repository?
tell me the rules and responsblites in our project(my project is development)
What are the types of caches in lookup?
How are indexes created after completing the load process?
Differences between connected and unconnected lookup?
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
How can one identify whether mapping is correct or not without connecting session?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Enlist few areas or real-time situations where informatica is required.
What do you mean by filter transformation?
What is mapplet in informatica?
whats the logic to load the lower level of granularity of data to fact table.
What are roles and groups and benefits of using them?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
