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
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What is the meaning of up gradation of repository?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What are the designer tools for creating transformations?
can anyone explain me about retail domain project in informatica?
What does refresh system mean, and what are its distinctive choice?
What are the components of Informatica? And what is the purpose of each?
What is Cognos script editor?
What is sequence generator transformation in informatica?
What are the informatica performance improvement tips
Explain how to import oracle sequence into informatica?
Can we create a node as a gateway node and the same node can be assigned to a grid?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Enterprise data warehouse your projects phase by phase explain?