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
- 6497 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
Explain your project of banking domian.
Differentiate between a database and data warehouse?
Write the program through which the records can be updated?
Mention few advantages of router transformation over filter transformation.
What will be the approach?
What is the procedure for creating independent data marts from informatica 7.1?
What is the advantage of informatica?
Explain in detail scd type 2 through mapping.
explain abt ur project architecture?
Tell me about MD5 functions in informatica
waht type of interface is used for testing the data in informatica
What are the transformations that are not supported in mapplet?
How can we improve session performance in aggregator transformation?
What are the performance considerations when working with aggregator transformation?
Clarify the aggregator change?
