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
- 1 Answers
- 2261 Views
- I also Faced
- E-Mail Answers
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 do you understand by a term domain?
What will happen if we have a filter transformation used in a mapping and in the filter condition we specify 1. Yes nothing else, only the number 1. In other words, assuming we have 10 rows coming to this filter transformation as an input, how many rows will be output by this transformation when we have only 1 in the filter condition?
Write the unconnected lookup syntax and how to return more than one column.
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
what is the hint? how to use it to reduce the query processing in program?
I want to get an license to produce excel format output using informatica tool. Anyone help me in this issue. Thanks in advance, Vishnuvardhan
What is decode in static cache?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
0 Answers Cognizant, Flextronics,
In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.
In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?
If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.
i want excute multiple sessions in one workflow using the "start task".what do i need to do?
Teradata 
