what is Partitioning ? where we can use Partition?
Answers were Sorted based on User's Feedback
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.
| Is This Answer Correct ? | 28 Yes | 5 No |
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/
| Is This Answer Correct ? | 4 Yes | 0 No |
Target is zero file and how can you send the email?
In which circumstances that informatica server creates Reject files?
I still need further explanation about the difference between active and passive transformation with some examples.Thank You
What are the new features of Power Center 5.0?
what is a transforamation?
Hi, This is Lakshmi,Anyone taking classes for datawarehouse-Informatica and BO with real time project
What is factless fact schema?
What is the difference between lookup override and souce qualifier override ?
what is incremantal aggregation?
I HAVE A SOURCE FILE CONTAINING 1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B AND IN TARGET I SHOULD GET LIKE 1|A+B+C+D 2|A+B 3|A+B WHICH TRANSFORMATION I SHOULD USE
What are the different types of repositories created using informatica?
if the session fails after 100 records agian we have to starts the session or we go for recovery session