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
How do you change a non-reusable transformation to reusable transformation?
Mention few advantages of router transformation over filter transformation.
permutations of mapplet
What is dimensional table?
Explain sessions?
How to do the error handling of if ur source is flatfiles?
write a query to retrieve the latest records from the table sorted by version(scd)
how many types of dimensions are available in informatica?
what are the Methods For Creating Reusable Transformations?
What are the designer tools for creating transformations?
On which transformations you created partitions in your project?
How to create Target definition for flat files?
When do you use sql override in a lookup transformation?
How to open an older version of an object in the workspace?
Have you worked with/created Parameter file
