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 |
List the transformation in informatica.
How to load duplicate records in to a target table which has a primary key?
How to create a non-reusable instance of reusable transformations?
without update strategy how to insert &update?
how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to vanibv6@gmail.com Thnx Vani
If I am having 6 flat files in data. How can you load the data at a time
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is polling in informatica ?
Can we combine a flatfile and a database table using an UNION transformation?
What are the out put files that the informatica server creates during the session running?
Differences between connected and unconnected lookup?