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
- 6605 Views
- I also Faced
- E-Mail Answers
Answer Posted / hari
use order by clause in source qualifier.
Remove un necessary ports in that lookup.
try to restrict lookup cache based on the source data.
create order by clause in lookup override using the lookup
condition columns.
If lookup and source are in same database try to join in
source qualifier.
Drop the indiex on the target table before loading the data.
Check index on source table,
Check source table look tables are analysed properly or not.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
How to create Target definition for flat files?
Describe expression transformation?
can u give example for factless fact table
What do think which one is the better joiner or look up?
What is the scenario which compels informatica server to reject files?
How to extract sap data using informatica?
what is the Default Source Option For Update Strategy Transformation?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Explain informatica architecture - version 8 / 9
What are the different components of powercenter?
What are ETL Tools?
What are the settings that you use to configure the joiner transformation?
How can a transformation be made reusable?
How big was your fact table
How does the aggregator transformation handle null values?
