What are partitions in informatica and which one is used
for better performance?

Answer Posted / srinu

Pipeline Partitioning Overview
Configuring Partitioning Information
Cache Partitioning
Round-Robin Partition Type
Hash Keys Partition Types
Key Range Partition Type ---BestPerformance
Pass-Through Partition Type
Database Partitioning Partition Type
Partitioning Relational Sources
Partitioning File Sources
Partitioning Relational Targets
Partitioning File Targets
Partitioning Joiner Transformations
Partitioning Lookup Transformations
Partitioning Sorter Transformations
Mapping Variables in Partitioned Pipelines
Partitioning Rules

Is This Answer Correct ?    2 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

1986


Explain informatica architecture - version 8 / 9

681


What are pre and post-session shell commands?

754


What is informatica? Why do we need it?

651


How to partition the Session?

656






How does a sorter cache works?

582


What is InformaticaPowerCenter?

704


Which transformation should we use to normalise the COBOL and relational sources?

755


What are the modules in Power Center

1246


Clarify the utilization of aggregator cache record?

586


How can you validate all mappings in the repository simultaneously?

768


What are the validations that you can perform in oracle and in informatica ? Advance Thanks

1668


How to load last n records of file into target table - informatica

611


if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

1785


Scheduling properties,whats the default (sequential)

1482