Answer / mahesh

The Partitioning Option increases Power Center?s
performance through parallel data processing, and this
option provides a thread-based architecture and automatic
data partitioning that optimizes parallel processing on
multiprocessor and grid-based hardware environments.
Partitions are used to optimize the session performance. We
can select in session properties for partitions
Types- Default----pass through partition, key range
partition, round robin partition, hash partition.

Answer / annu

Partitioning is a utility provided by informatica which
evolves nature of parallel processing on a grid or
multiprocessor database architecture. Partition means
a "thread of ETL data load in chunks". Like Unix, Multiple
data load thead will be executed parallely and sync up the
result set to one instance of Target.

For more detail of using Informatica Partitioning with
visual graphs
visit : http://informatica-tech-talk.blogspot.com/

What is the advantage of informatica?

0 Answers  

---

Define enterprise data warehousing?

0 Answers  

---

What are the informatica performance improvement tips

0 Answers   Informatica,

---

How we can get unique records into one target table and duplicate records into another target table??

11 Answers   Deloitte, IBM, iGate,

---

What are mapplets?

0 Answers  

---

What is sequence generator transformation in informatica?

0 Answers  

---

Describe an informatica powercenter?

0 Answers  

---

if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.

5 Answers   Wipro,

---

What are the reusable transformations?

0 Answers   Informatica,

---

when we go for unconnected lookup transformation? and why?

5 Answers   Accenture,

---

Explain the different kinds of facts.

0 Answers  

---

What is union transformation in informatica?

0 Answers  

---