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 |
enterprise datawarehouse your project phase by phase explain?
i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need
My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1 from dual? what is the out put of the above queries?
How do you create single lookup transformation using multiple tables?
How might one distinguish in the case of mapping is right or not without associating session?
What is the Difference between DSS & OLTP?
What is decode in informatica?
why we use informatica in our project?
What is synonym?
What are the new features in Informatica 5.0?
how can we calculate fact table size?
What is the difference between normal and bulk loading? Which one is recommended?