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
- 5764 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
What is a code page?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
What is source qualifier transformation in informatica?
What is domain and gateway node?
What is meant by incremental aggregation?
How to do the error handling of if ur source is flatfiles?
What are the components of the workflow manager?
Whats there in global repository
What are the performance considerations when working with aggregator transformation?
How can you define user defied event?
Explain target update override in informatica
Which version configuration tool used in ur project?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
Can informatica load heterogeneous targets from heterogeneous sources?
How do you handle two sessions in Informatica
