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 |
how we can do session partition in informatica any one explain me clearly? thanks advance.
when will we go for unconnected lookup transformation in Informatica?
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.
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?
What are the components of workflow manager?
what are the row and column separations in Flat Files
What are the types of maping in Getting Started Wizard?
how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy
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?
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?
I want to get an license to produce excel format output using informatica tool. Anyone help me in this issue. Thanks in advance, Vishnuvardhan
Normalizer transformation is not involved in Mapplet.. why???