performance tuning of Informatica
Answer / chandumba2005
• Increase performance by indexing the primary key-foreign
keys if the source table has more than 1,000 rows
• Improve session performance by caching small lookup tables
• Use reusable Lookup transformation instead of using same
Lookup Transformation multiple times
• Use source filter in the Properties tab to reduce the
number of rows
• Reduce the number of transformation.
• Delete unnecessary links between transformations to
minimize the amount of data moved, especially in the Source
Qualifier
• Plan for reusable transformations
• Use mapplets to encapsulate multiple reusable transformations.
• Use variable ports to calculate a value that can be used
multiple times
• Numeric operations are faster than string operations
• Operators are faster than function. Example: || is faster
than concat()
Is This Answer Correct ? | 1 Yes | 1 No |
What are the different components of powercenter?
I have a scenario which load the data frm single source to 2 targets as T1, T2, and T1 have a P.K and T2 have F.K relations. first data has to load in T2, and then data load to T1 if that record exist in T1... how can we acheive it?
what is metadata?
what is hash table in informatica?
Define mapping and session?
What is synonym?
Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.
What are the differences between a connected lookup and unconnected lookup?
How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?
What is Session and Batches?
How to create or import flat file definition in to the warehouse designer?
when will we go for unconnected lookup transformation in Informatica?