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???????
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
What are the data movement modes in informatica?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
how to run two workflow(not a sessions) sequentially, what is the process. Plz explain detailed information.
When do you use sql override in a lookup transformation?
What are the different threads in DTM process?
If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks
What is a grid in Informatica?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
What is the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?
Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how
Which is better performance wise database or file?How?
What is repository manager?