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

What all are steps in up gradation of Informatica server?

617


can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3320


Explain your project of banking domian.

1216


in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

1730


Mention a few design and development best practices for informatica?

557






write a query to retrieve the latest records from the table sorted by version(scd)

630


Explain lookup transformation in informatica

642


Describe data concatenation?

568


In informatica workflow manager, how many repositories can be created?

778


Did u used latest transformations of 8.6.0? for what?

1473


explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

1699


How can you increase the performance in joiner transformation?

704


Describe an informatica powercenter?

606


How do you update the records with or without using update strategy?

660


What are the components of workflow manager?

585