Interested to Buy Any Domain ? << Click Here >> for more details...
What is performance tuning in informatica. What measures
you will take if some thing is taking much time in your
process of ETL?
- 1 Answers
- 9667 Views
- Altisource, Patni, I also Faced
- E-Mail Answers
Answer Posted / mike
The goal of performance tuning is optimizing the session
performance. so session runs during available load window
for the informatica server. To increase the session
performance we need to follow the below steps
1)The performance of the informatica server is related to
the network connections. Generally data moves across the
network at less than 1 mb per second, where as local disk
moves five to twenty times faster. so network connections
aften affect the session performance.Hence avoiding the
network connections session performance gets increased.
2)If your flat files are stored in a machine other than
informatica server, need to move the files where
informatica server exists.
3)By minimizing connection to sources, targets and
informatica server session performance gets increased.
4)By running multiple informatica servers against same
repository, thus distributing the session load on multiple
servers may increase session performance.
5)By running the informatica server in ASCII data movement
mode session performance gets improves this is because,
ASCII mode stores a character value in one byte where as
UNICODE mode stores 2 bytes per character.
6)By avoiding transformation errors session performance
gets increased.
7)If a session having aggregator t/r, we can use
incremental aggregation to improve session performance.
8)If a session having lookup t/r , by enabling lookup
chache session performance gets increased.
9)aggregator, rank, joiner t/r's will always slows down the
data load this is because they must group the data before
processing it. In such case by using sorted input option we
can improve session performance.
10)If your target contains key constraints and indexes, it
may slow down the data load. In such case need to drop the
constraints and indexes and rebild them after completing
the session....
If something was taking much time need to check the
bottlenecks starting from
source,target,transformation,mapping,session,workflow
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
What are ETL Tools?
How can we improve session performance in aggregator transformation?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is decode in static cache?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Which files are created during the session rums by informatics server?
What are the mapping parameters and mapping variables?
What is the commit type if you have a transaction control transformation in the mapping?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What are the advantages of using informatica as an etl tool over teradata?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What is DR strategy for Informatica project?
How many ways are there to create ports?
How to load last n records of file into target table - informatica
Explain the shared cache and re-cache?
