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
- 6372 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 does “tail –f” command do and what is its use as an Informatica admin.
explain about unit testing? in real time?
what is song in infrmatica...?
What is joiner change?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is DR strategy for Informatica project?
Explain pmcmd command usage in informatica
How do you load only null records into target? Explain through mapping flow.
Explain the types of lookup transformation?
What are the limitations of joiner transformation?
Explain the different dimensions.
Can we create two repositories on same database instance in oracle?
What are the new features of informatica 9.x developer?
What is the format of informatica objects in a repository?
what are factless facts? And in which scenario will you use such kinds of fact tables.
