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 is the difference between Normal load and Bulk load?
What are session parameters ? How do you set them?
What is the difference between informatica 7.0 and 8.0?
In a sequential batch can u run the session if previous session fails?
111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?
I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, third record in target 3, 4 th record again in target 11, 5th again in target 2, 6th again in target3 etc.... how it is possible?
how many session run unix environment what command using ?
what is bitmap index? did u use it?and how to use it in informatica
When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?
if i have a delimited file as source so how can we seperate this file into three diff targets?
What is domain and gateway node?
Do you have knowledge in ralph kimball methodology