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
What is the benefit of partitioning a session?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What are the limitations of joiner transformation?
Explain sessions. Explain how batches are used to combine executions?
Can we get 1st record through Informatica(without sequence number).
Enterprise data warehouse your projects phase by phase explain?
What is rank index in rank transformation?
What are the settings that you use to configure the joiner transformation?
As union transformation gives UNION ALL output, how you will get the UNION output?
How can you generate reports in informatica?
Can we override a native sql query within informatica?
What is meant by query override?
What is an expression transformation?
Where is metadata stored?
What is the command used to run a batch?