What are partitions in informatica and which one is used
for better performance?
- 2 Answers
- 14904 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Which is the best place to learn Informatica Powercenter Online Training?
checkout and checkin in informatica 8.6
How will u find weather dimension table is big in size of a fact table?
ename,deptcount vamshi,3 kumar,5 krish,8 in o/p i want vamshi record 3 times kumar record 5 times like wise what is the logic.? give the entire logic plz
when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?
select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?
Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?
how to create user defined function (udf) in informatica
Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..
How to convert flat file into xml file? How to tune joiner?
What does cheating measurement mean?
difference between shortcut and reusable transformation?
Teradata 
