Interested to Buy Any Domain ? << Click Here >> for more details...
how we do performence tuning in informatica
- 3 Answers
- 7770 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Perf Tune is not an simple Question !!!!
its a process !!!
Performance of Informatica is dependant on the performance
of its several components like database, network,
transformations, mappings, sessions etc. To tune the
performance of Informatica, we have to identify the
bottleneck first. Bottleneck may be present in source,
target, transformations, mapping, session, database or
network.
Identify bottleneck in Source
Identify bottleneck in Target
Identify bottleneck in Transformation
Identify bottleneck in sessions
DATABASE OPTIMISATION
OPTIMUM CACHE SIZE IN LOOKUPS
so and so,,,,,,,,,,,,,,,,
| Is This Answer Correct ? | 5 Yes | 2 No |
First we need to identify the bottlenecks,
Then we need to do peer review
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / karthik
Guys we know the bottle necks, but pls tel us how do we
resolve it..
for example :
if source is reading the date very slowly, how do we solve
that??
| Is This Answer Correct ? | 0 Yes | 0 No |
Why is sorter an active transformation?
my sourse is like id name sal--1 aa 1000 ,2 bb 2000, 3 cc 3000 4 dd 4000, 5 ee 6000 , 6 ff 7000 and so on but myrequirement is like this id name sal up_sal,1 aa 1000 null,2 bb 2000 1000, 3 cc 3000 2000 4 dd 4000 3000, 5 ee 5000 4000 , 6 ff 6000 50000 and so on so how can i get it plez reply for this as soon as possible , thanks in advanced
WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?
Can u generate reports in Informatica?
In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, col2 and 1,x and 1,y and 2,a and 2,b, what is the procedure?
hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE USING SQL T/R ?
if i am having 10 records in source, i want 20 records in target...how will you do it
How to load the data from a flat file into the target where the source flat file name changes daily?
what are challenges that you faced in testing? give solution to it?
what is song in infrmatica...?
What is a filter transformation and why it is an active one?
What happens if we dont select data driven option?
Teradata 
