Interested to Buy Any Domain ? << Click Here >> for more details...
what is Partitioning ? where we can use Partition?
- 2 Answers
- 23141 Views
- IBM, TCS, I also Faced
- E-Mail Answers
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 |
In Flat file Input is A B C I need output like this A A A B B B C C C. How will u achieve this?
Using Connected or unconnected lookup for performance wise which one is preferable?.
Explian the connected and unconnected lookup transformation
What is the use of target designer?
How can yoU improve session performance in aggregator transformation?
Do you find any difficulty while working with flat files as source and target?
How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.
what is mapping optimization? wat are the techniques for tat
List the transformation in informatica.
Any one can tell me how to explain puss-down optimization ? explain me with example plz?
In which circumstances that informatica server creates Reject files?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Teradata 
