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

Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

0 Answers  


Hi All can anyone tell me where i will get Informatica training in Mumbai?

3 Answers  


What is standalone command task?

0 Answers  


What could be the possible resons of locks by user?

0 Answers  


Hi, This is Lakshmi,Anyone taking classes for datawarehouse-Informatica and BO with real time project

2 Answers  






Filter transformation in the condition one of the data is NULL would the record be dropped.

2 Answers  


I have been working in Informix-4gl for the past 2 years in an MNC company.But I'm interested to work in Business Intelligence tools. Is it possible to change the technology now? I'm really confused, please help me

1 Answers  


By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?

5 Answers   Keane India Ltd,


Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

0 Answers   TCS,


what is persistant cache in which situation we will use persistantcache

1 Answers   HCL,


can we send mail when ever it get success or faulure to other mailid?(Not company mail id)

1 Answers   Puma,


Define joiner transformation?

0 Answers  


Categories