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 / 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 |
What are Dimensional table?
How the informatica server increases the session performance through partitioning the source?
How to display null values on a target & non-null values on a target?
How to extract sap data using informatica?
What are the tasks that can be performed using sq?
while creating the scd mappings. we will mention flag value. what exactly the use of defining the FLAG VALUE. Please explaine indetaile
What is the use of code page?
If you done any modifications for a table in back end does it reflect in informatca warehouse or maping?
i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informatica
How to merge First Name & Last Name?
Hi experts, can anyone tell how much we use plsql in real time
How to eliminate duplicates in FF and oracle both