Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance
issue. how to fix the performnce issue of the query.
No Answer is Posted For this Question
Be the First to Post Answer
Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?
What are the components of Informatica? And what is the purpose of each?
What are the restrictions of union transformation?
i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time
can u give example for factless fact table
What is the function of look up transformation?
1 2 3 * 4 5 6 * 7 8 9 how to load records between two stars(*),
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 is the gap analysis?
Performance tuning( what you did in performance tuning)
Can we use unconnected lookup as dynamic lookup?
5 Answers ITC Infotech, TCS, Wipro,
How can you recover the session in sequential batches?