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
- 6365 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
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
4 yrs etl devloper roles and responsibilities?any body give solutions
What are the tasks that can be performed using sq?
is it possible to index the data in cache of lkp transformation ?
What is meant by pre and post session shell command?
What is dimensional table?
can u give example for factless fact table
what is SDLC way of code development?
What is the sequence generator transformation in informatica?
Can we change Dynamic to Static or Persistent cache? If so what happens?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What are the designer tools for creating transformations?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
While importing the relational source definition from the database, what are the metadata of source that will be imported?
can we override a native sql query within informatica? How do we do it?
