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 we can do session partition in informatica any one explain me clearly? thanks advance.

1 Answers   iGate,


when will we go for unconnected lookup transformation in Informatica?

6 Answers   CTS, IBM,


how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.

1 Answers  


i have source file data empno,ename,sal 100,ram,1000 200,tyu,2000 300,gh,3000 out put as e empno,ename,sal 100,ram,null 200,tyu,1000 300,gh,2000 how to load it?

5 Answers   Cap Gemini,


What are the components of workflow manager?

0 Answers  


what are the row and column separations in Flat Files

3 Answers   CTS,


What are the types of maping in Getting Started Wizard?

1 Answers  


how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy

2 Answers   TCS,


I am using mapping variable, when i am running a session,before it has 10000 records, after completion of session what about value of mapping variable?

1 Answers  


If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?

4 Answers  


I want to get an license to produce excel format output using informatica tool. Anyone help me in this issue. Thanks in advance, Vishnuvardhan

1 Answers  


Normalizer transformation is not involved in Mapplet.. why???

1 Answers   Wipro,


Categories