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
can we override a native sql query within informatica? Where do we do it?
What is a joiner transformation and why it is an active one?
Define mapping and session?
How can we improve session performance in aggregator transformation?
How can we store previous session logs?
What is the meaning of up gradation of repository?
can anyone suggest best free Talend data integration training online
What is a filter transformation?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
-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?
What are the different options available for update strategy?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
Explain the mapping variable usage example in informatica
What is the way to execute pl/sql script using informatica mapping?
What are the different ways to implement parallel processing in informatica?
