Interested to Buy Any Domain ? << Click Here >> for more details...
If we use only lookup transformation in a mapping ie,
SourceQualifier-->Lookup --> Target. , here datas are taking
very long time to load in target., so what are steps to
improve the performance in that mapping???????
- 2 Answers
- 6501 Views
- I also Faced
- E-Mail Answers
Answer Posted / murali udayagiri
One more point we can add to the first answer.
i.e
Check lookup condition columns are having indexes or not.
If indexes are present check when those are rebuild.Index
snaps are old then rebuild them before going to be start
session.If indexes are not present on conditional columns
just create.
Please let me know if any issues.
Thanks,
Murali Udayagiri
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How do you use reject loader.
How many dimensions are there in informatica?
What are the different types of olap? Give an example?
What is the use of an aggregator cache file?
How might you approve all mappings in the archive all the while?
Can we create a node as a gateway node and the same node can be assigned to a grid?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What are ETL Tools?
How union transformation is used?
Explain lookup transformation is active in informatica
What is aggregator transformation in informatica?
scenario where i can use only concurrent execution of workflow.
How to create or import flat file definition in to the warehouse designer?
What is dimensional table? Explain the different dimensions.
tell me 5 session failure in real time how can you solve that in your project?
