Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
Under what condition selecting sorted input in aggregator may fail the session?
What is lookup transformation?
Explain constraint based loading in informatica
What does reusable transformation mean?
have u done any performance tuning? how u ll do?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
How to join three sources using joiner? Explain though mapping flow.
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
How you know when to use a static cache and dynamic cache in lookup transformation?
What is different between the data warehouse and data mart?
What are the components of Informatica? And what is the purpose of each?
How to use pmcmd utility command?
What is primary and backup node?
When do you use sql override in a lookup transformation?
As union transformation gives UNION ALL output, how you will get the UNION output?
