performance tuning of Informatica
- 1 Answers
- 4615 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What is aggregator transformation in informatica?
How to elaborate powercenter integration service?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What aer the out put files that the informatica server creates during the session running?
tell me some dimension tables names in banking domain informatica project(dont tell like depends on project, tell me names of dimension and fact table names in your project)?
What is persistent lookup cache?
Explain how to import oracle sequence into informatica?
Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000. but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer
What is the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?
What are the data movement modes in informatica?
How will you display 10-15 letters from a name? (for ex: name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam")
why we use datawarehouse
Teradata 
