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 |
Hi experts ,I have a Source of 1000 records.I have to load 100 records in first target,101 to 200 records in 2nd target, 201 to 300 records in 3rd target and again 301 to 400 in first target like that as cyclick process. How can i acheive this.
why cant we put a sequence generator or upd strategy transformation before joiner transformation?
What is the filename which you need to configure in UNIX while installing infromatica?
Tell me about Propagate functions in informatica
Clarify the aggregator change?
What is the procedure for creating independent data marts from informatica 7.1?
I have the input file as col1 col2 col3 3 2 1 7 6 8 I should get the output as col1 col2 col3 1 2 3 6 7 8 ....What is the logic to get this? Is there any transformation which sorts row wise ? If not how to sort the incoming records row wise?
How we will implement Pushdown Optimization and Types in Informatica with better examples
HOW DO YOU CONNECT TO REMOTE SERVER ?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
what is tha tracesing level? and difference betweentrace in normal and verbose and nonverbose?
Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.