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
What is a grid in Informatica?
What is meant by pre and post session shell command?
Is there any way to read the ms excel datas directly into informatica?
tell me about your project functionality
How does the aggregator transformation handle null values?
can u give example for factless fact table
What is a dimensional model?
Explain lookup transformation in informatica
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
How would you join a node to the already existing domain?
What all join we can perform in LOOKUP transformation?
During the running session, output files are created by informatica server. Enlist few of them.
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 ?
Differentiate between sessions and batches?
Repository user profiles
