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 ?||27 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
visit : http://informatica-tech-talk.blogspot.com/
|Is This Answer Correct ?||4 Yes||0 No|
i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.
Hello...... How can i set my mapping as read-only? Please answer me. Advance thanks
Explain the different dimensions.
What is the target load order?
why we r using presql&postsql in source qualifier?
What is a diff between joiner and lookup transformation
How to improve the performance of Aggregate transformation?
sample mappings for scd1,scd2 and scd3
What is difference between a connected look up and unconnected look up?
what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?
CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING? IF SO HOW?
which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..