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

Can you start a batches with in a batch?

1 Answers  

---

what are the differences between powercenter 8.1 and powercenter 8.5?

2 Answers  

---

in what type of scenario bulk loading and normal loading we use?

2 Answers   Cognizant, Wipro,

---

i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me

2 Answers  

---

What is meant by a domain?

0 Answers  

---

---

what is parallel querying and what r hints.

1 Answers  

---

How to load the name of the current processing flat file along with the data into the target using informatica mapping?

0 Answers   Informatica,

---

If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?

1 Answers   TCS,

---

Source (Flatfile) - Target (1-1 mapping). How to load first or last 20 record to target?

5 Answers   Flextronics,

---

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

4 Answers  

---

What is operational data source (ODS)?

7 Answers  

---

What are the types of schemas we have in data warehouse.

0 Answers  

---