Interested to Buy Any Domain ? << Click Here >> for more details...
performance tuning of Informatica
- 1 Answers
- 5398 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 |
I'd like the load to be triggered by client. By placement of a file or somehow. How is it done in Informatica? I'm using version 7.1.4 This is so urgent - I really appreciate your help :-)
3 Answers Alcatel-Lucent, ECI Telecom,
Scenario is like this: Name Sal A 10; B 20; C 30; Then Output should be Name Sal A 10; B 20; C 30; Total 60; Use SQL For this scenario
What are the associated ports in look up T/R.
What do you mean by enterprise data warehousing?
What are parallel querys and query hints?
what type of documents you receiving from client later wt can you do? what type of documents have to prepare?
What is the need of building a data warehouse?
How we can confirm all mappings in the repository simultaneously?
What are the phases in SDLC?
Define enterprise data warehousing?
select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?
My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following EmpID, Salary, Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103, 3000, 6000). Please guide on how to build the mapping.
Teradata 
