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
- 6493 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 can a transformation be made reusable?
Is it possible to define a single node as a Gateway node as well as worker node?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
How to extract sap data using informatica?
Quickly characterize reusable change?
What is meant by lookup transformation?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
what is the -ve test case in your project.
What is union transformation in informatica?
Explain what are the different versions of informatica?
What is the status code in stored procedure transformation?
Explain why we use partitioning the session in informatica?
Differentiate between source qualifier and filter transformation?
What is a predefined event?
expain about the tune parameters?
