Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3582 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 is data modelling? what are types of modelling?In which suituation will use each one?
can session assigned multiple mappings or not?
write sql query following table city gender no chennai male 40 chennai female 35 bangalore male 25 bangalore female 25 mumbai female 15 i want the required output city male female chennai 40 35 bangalore 25 25 mumbai 15
if the column name in sql override is diff from the column name in source qualifier,what is the impact?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
Source-1 No name 1 satish 2 karthik 3 swathi 4 keerthi Source-2 No name 1 satish 2 karthik 5 santhose 6 vasu Target 3 swathi 4 keerthi 5 santhose 6 vasu here i want non matching Records i want how to achieve that
What is the benefit of partitioning a session?
My source is this year 01/jun/2014 04/may/2015 09/mar/2017 my desired output is day month ye 01 jun 2014 04 may 2015 09 mar 2017 how do i acheive this
How can you join two tables without any common column present in them?
How many types of sessions are there in informatica.please explain them?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
How to compare Source and Target table, without using dynamic lookup?
Teradata 
