Interested to Buy Any Domain ? << Click Here >> for more details...
how we do performence tuning in informatica
- 3 Answers
- 7921 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 |
How to load the data from a flat file into the target where the source flat file name changes daily?
How do you convert single row from source into three rows into target?
MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104 MY REQUIRMENT IS NAME ID VENKATESH 101 RAJESH 102 SIVA 103 SWATHI 104 PLEASE PROVIDE ME THE SOLUTION
What is a rank transform?
Name the different lookup cache(s)?
Do joiner transformation use cache? If so describe?
What is deployment group?
What is a code page in Informatica
3 Answers American Express, Cognizant, Deloitte,
What is DR strategy for Informatica project?
i have 50500 records in my source.if wf run for the first time it will load 1000 records into 1 tgt,if runs second time it will load to another tgt.targets are FF and it is need to be created dynamically.how many tgt will be created and how?
What are the types of caches in lookup?
if i have a file having record sal=10000,and when use router with two groups having condition sal>5000 in one group,sal>7000 in other group.and if two groups connected to two targets.in which target sal=10000 will go?
9 Answers BirlaSoft, Genpact, L&T, Syntel,
Teradata 
