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
Explain in detail about scd type 1 through mapping.
Explain the code page compatibility?
What is joiner transformation?
How can repository reports be accessed without sql or other transformations?
difference between informatica 8.1.1 and 8.6
What is lookup transformation?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What is olap (on-line analytical processing?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What is the function of look up transformation?
What is a filter transformation and why it is an active one?
What are the limitations of joiner transformation?
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?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
tell me 5 session failure in real time how can you solve that in your project?