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 the difference between source qualifier transformations source filter to filter transformation?
What is repository manager?
What is the session task and command task?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
how many types of dimensions are available in informatica?
How do we call shell scripts from informatica?
What is a difference between complete, stop and abort?
How do you change a non-reusable transformation to reusable transformation?
How to update a particular record in target with out running whole workflow?
What is meant by lookup transformation? Explain the types of lookup transformation?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Define enterprise data warehousing?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Mention few advantages of router transformation over filter transformation.
Describe data concatenation?
