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???????
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
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
How to generate or load values in to the target table based on a column value using informatica etl tool.
Explain the difference between mapping parameter and mapping variable?
What is complex mapping?
Explain why we use partitioning the session in informatica?
What are the components of the workflow manager?
is it possible to index the data in cache of lkp transformation ?
Why update strategy and union transformations are active? Explain with examples.
Explain sql transformation in script mode examples in informatica
How can we create index after completion of load process?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
What is update strategy transform?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What is deployment group?
What is data transformation manager process?