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 |
Which means the first record should come as last record and last record should come as first record and load into the target file?
what is metadata?
What are Rapid changing dimensions?
What is the command used to run a batch?
Can you please mail me a copy of Informatica Certification Exam dumps to sriveniv@hotmail.com
Can informatica load heterogeneous targets from heterogeneous sources?
what is mapping optimization? wat are the techniques for tat
what is DSS?
What are the types of data warehouses?
How to Display top 2 salaries for each department WITHOUT using Rank Transformation And WITHOUT using SQL queries in source qualifier.
What are the tuning techniques you applied during your last project
Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation