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

Answers were Sorted based on User's Feedback



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

Answer / sri

Round robin
Data base
Hash key
Pass through
Key range

Is This Answer Correct ?    20 Yes 1 No

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

Answer / 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

More Informatica Interview Questions

how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table

2 Answers  


In target table how to display the system time

1 Answers  


What is rank index in rank transformation?

0 Answers  


Source Qualifier is an active t/r but there is no change of row count then y should we called it active t/r & Router , sorter some times no change in row count then Y we called its active t/r?

2 Answers  


source target Q410 4 2010 Q311 3 2011 Q412 4 2012 Q309 3 2009

1 Answers   IBM,






What are the types of groups in Router transformation?

1 Answers   Informatica,


generate date / time dimension in informatica

0 Answers   Informatica,


How can we integrate different flat file data in a single mapping and with in a single execution

1 Answers  


How you load distinct records into one target and duplicate records into another target?

3 Answers   Mphasis,


explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???

8 Answers   CTS, TCS,


Find a way to implement the following logic : You have column like : Column 1 AA|BB|CC DD|EE|FF WW|AA I need to get the length of the column without the ‘|’ .

5 Answers  


which transformation should we use to get the 5th rank member from a table in informatica?can we achieve this in sql?

6 Answers   IBM,


Categories