What are partitions in informatica and which one is used
for better performance?
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 |
Explain where to store informatica rejected data? How to extract the informatica rejected data?
In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?
wht is cdc?how to use it in creation of mappings?
WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED FOR INSERT , UPDATE OPRATION ?
without table how to come first record only in oracle?
Can any one explain or sujjest some sites for scd mappings.Thank you
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Hi, Can someone send me the DWH and Informatica FAQ's at vanibv6@gmail.com Thanks in Advance, Vani
I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution
1 lac of flat fles in source how to load target at a time?
.prm wirh repalce .txt is possible?
is it reqire primary key and foreign key relation ship to join relational databases?if yes? explain?