Interested to Buy Any Domain ? << Click Here >> for more details...
performance tuning of Informatica
- 1 Answers
- 5318 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 the difference between look up and joiner(don't say joiner sopport only = where as look up support non-equijoin).
How we can use union transformation?
Diff b/w ShortCut and reusabel Object ?
How to load last n records of file into target table - informatica
why we are using surogate key in real time give me explanation
How to load a Dimension ? and how to load a fact table?
What are the basic needs to join two sources in a source qualifier?
how to load only the first and last record of a flat file into the target?
What is a repository? And how to add it in an informatica client?
Can we create out put ports in source qualifier t/r?
source table have single column single record having with single space. load that source record into trg . trgt having two columns and the SOURCE TABLE LIKE COL1 BHANU PRASAD TRGT TABLE COL1 COL2 IN THAT LOAD THE RECORD IN THE trgt table LIKE COL1 COL2 BHANU PRASAD HOW ? TELL ME PLZ
Q. Informatica workflow, it is running beyond two hours for last couple of runs, normally it completed less then 30 min., hardly 40 min, last couple of run crossing 2 hours and more in that workflow only one session. now it is aasign to you that how to idenitfy the performance issue of the sesion of production.
Teradata 
