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
Explain pushdown optimization $pushdownconfig parameter - informatica
explain one complex mapping with logic? sales project?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
How do you set a varible in incremental aggregation
what is $$$$?
What is the format of informatica objects in a repository?
can anyone suggest best free Talend data integration training online
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Why update strategy and union transformations are active? Explain with examples.
How many numbers of sessions can one group in batches?
How does the aggregator transformation handle null values?
Which version configuration tool used in ur project?
update strategy transformation in informatica
How do you load first and last records into target table?
