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 is the surrogate key?
What are the circumstances that infromatica server results an unreciverable session?
write a query to remove null value follwing table? col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output col1 col2 col3 dinesh suresh prakesh
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What are the different versions of informatica?
i want excute multiple sessions in one workflow using the "start task".what do i need to do?
Source is a flat file and want to load unique and duplicate records separately into two separate targets; right??
without update strategy how to insert &update?
explain abt union t/r?
tell me the informatica architecture
Explain pushdown optimization and types in informatica