what is Partitioning ? where we can use Partition?
Answer Posted / 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 |
Post New Answer View All Answers
What is blocking transformation?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What is Session and Batches?
What is informatica? Why do we need it?
Is it possible to use a client with different version than that of its Informatica server?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Explain how to import oracle sequence into informatica?
What is olap (on-line analytical processing?
Briefly describe lookup transformation?
how tokens will generate?
Can you generate sequence numbers without using the sequence generator transformation?
Explain why we use partitioning the session in informatica?
Repository user profiles
What is the different lookup cache(s)?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?