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
- 6604 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
Explain how to import oracle sequence into informatica?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What do you mean by blocking transformation?
What are the components of Informatica? And what is the purpose of each?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What is depict expression change?
Write the prerequisite tasks to achieve the session partition?
Explain the scenario which compels informatica server to reject files?
how to load rows into fact table in data warehouse
How to delete duplicate row using informatica?
How many input parameters can exist in an unconnected lookup?
How many types of sessions are there in informatica.please explain them?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Can you generate sequence numbers without using the sequence generator transformation?
what is the complex transformation you used in informatica
