How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target
Answer Posted / ratna
Performance tuning is a trail and error method. By using the session Log we would like to know where the bottle neck is. For each session DTM processor creates one reader, one transformation and one writer thread will create. In session log we can find Buzzy time. which is having the highest buzzy percentage that where the bottleneck present. We have to over come this by using the performance tuning Technics.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is informatica metadata?
How you know when to use a static cache and dynamic cache in lookup transformation?
What is a sorter transformation?
Define pmcmd command?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Can we create a Integration service without a Repository service and vice versa?
permutations of mapplet
How can a transformation be made reusable?
What is the difference between Active and Passive transformation?
whats the logic to load the lower level of granularity of data to fact table.
How can informatica be used for an organization?
What is the use of code page?
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?
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
pmscmd startworkflow -sv