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
- 6514 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
can anyone explain me about retail domain project in informatica?
What is meant by lookup transformation? Explain the types of lookup transformation?
What could be the possible resons of locks by user?
what is diff b/t sorter t/r and agg have the option sorter property...
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is the difference between Active and Passive transformation?
What is a filter transformation?
What are ETL Tools?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is a filter transformation and why it is an active one?
What are the mapping parameters and mapping variables?
where to store informatica rejected data? How to extract the informatica rejected data?
What do you mean incremental aggregation?
