how we do performence tuning in informatica
- 3 Answers
- 6876 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 |
If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?
What is exclusive and normal mode for repository services?
How many types of sessions are there in informatica.please explain them?
what are the output files that the informatica server creats during running a session?
what are objects in data warehouse?
I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.
Can we use Lookup instead of Joiner to join 2 tables? If yes which is faster and why?
Hi, This is Lakshmi,Anyone taking classes for datawarehouse-Informatica and BO with real time project
Hi all,Can any one provide me Informatica Designer Certification dumps.I need all three papers dumps.If any one has these dumps then plz send it on this id:- nagesh.jujjuru@yahoo.com Thanks in advance
What is IQD file?
How will you convert rows into columns or columns into rows
how can import the data from the flat files?
Teradata 
