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
- 5554 Views
- I also Faced
- E-Mail Answers
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 |
How to Create a folder using pmrep command?
How to eliminate 1st and last rows from the source and load the inbetween rows.
Is informatica power center designer has 64 bit support?
Name 4 output files that informatica server creates during session running?
HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND REMAINING TO OTHER TARGET?
What do you mean by channel change?
What are the types of caches in lookup? Explain them.
What are the basic needs to join two sources in a source qualifier?
What is the approximate size of data warehouse?
6 Answers Accenture, i3 Solutions,
What are the different clients of powercenter?
Define Pmrep command?
What are the different threads in DTM process?
Teradata 
