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
- 6524 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 can we convert a column into row in informatica? Eg: INPUT- a x Output Like: a b c b y x y z c z
How do you remove duplicate records in informatica?
Hi , Please help how to achieve the following scenario. I have a source table like this. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU I need the data in the target table like below. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU 4 Rajesh 5th SKU The Last row values we have.. and we have to append this last row in the target table. Thanks and Regards Nataraj V
HOW DO YOU CONNECT TO REMOTE SERVER ?
Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.
What are steps to follow Informatica migration from 7x to 8x? Pls Explain...
what is unique constraint error ?
How might you approve all mappings in the archive all the while?
In development project what is the process to follow for an etl developer from day1
How can we use batches?
What is domain in terms of informatica?
tell me the push down optimization
Teradata 
