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



How did you handle performance issues If you have data coming in from multiple sources, just walk th..

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

Post New Answer

More Informatica Interview Questions

Name at least 5 different types of transformations used in mapping design and state the use of each.?

0 Answers   Informatica,


Explain the features of connected and unconnected lookup.

0 Answers  


What are data-driven sessions?

0 Answers  


Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

0 Answers  


what is the difference between lookupoveride and joiner?

3 Answers  






What is data merging, data cleansing and sampling?

6 Answers   Satyam,


i have 50500 records in my source.if wf run for the first time it will load 1000 records into 1 tgt,if runs second time it will load to another tgt.targets are FF and it is need to be created dynamically.how many tgt will be created and how?

1 Answers   HCL,


can you please explain me pre session and post session options?

3 Answers   BTBP,


Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

3 Answers   Infotech,


Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

0 Answers   TCS,


Define the various join types of joiner transformation?

0 Answers  


i have 1000 record flat file source i want 1st row to 1st target, 2nd row to 2nd target, 3rd row to 3rd target how will u do? Without using Mod Function? Explain....

4 Answers   TCS,


Categories