Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?



What is performance tuning in informatica. What measures you will take if some thing is taking muc..

Answer / 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

More Informatica Interview Questions

What is the use of target designer?

0 Answers  


What is the function of look up transformation?

0 Answers  


What is the command used to run a batch?

0 Answers  


What is the role of informatica in project ?Like i showed financial projects?

1 Answers   Amdocs,


source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000

7 Answers   Cap Gemini,


waht is dataware house

2 Answers  


in mapping i have one source and five targets in that data will be loaded into four targets properily in one target the data is not loaded how will u rectify

3 Answers   Patni,


What will happen when Mapping variable and Mapping parameter is not defined or given? Where do you use mapping variable and mapping parameter?

10 Answers   Deloitte,


i want excute multiple sessions in one workflow using the "start task".what do i need to do?

2 Answers  


How to generate sequence numbers using expression transformation?

0 Answers   Informatica,


what is target update override and when we use it?

2 Answers   TCS,


write a query row to column follwing source? quarter sales q1 5000 q1 9000 q1 7000 q1 6000 q2 5000 q2 4000 q2 3000 q2 1000 q3 4000 q3 3000 q3 1000 q3 2000 q4 5000 q4 400 i want the output? q1 q2 q3 q4 sales

3 Answers   Cognizant, Flextronics,


Categories