What are partitions in informatica and which one is used
for better performance?
- 2 Answers
- 14929 Views
- I also Faced
- E-Mail Answers
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
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
What is enterprise data warehousing?
Informatica settings are available in which file?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Could you explain what is enterprise data warehouse?
What is the difference between informatica 7.0 and 8.0?
What is a code page?
What could be the possible resons of locks by user?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What is incremental aggregation?
what are the deliverables?in your project?
Differentiate between Load Manager and DTM?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
Differentiate between a database and data warehouse?
