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
- 6409 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 |
what is metadata?
What are Rapid changing dimensions?
how to we create datamart?
What are the guidelines to be followed while using union transformation?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What are the challenges of Dataware housing in the future?
My questions is i create a two sessions for one mapping.but my requirement is if all number of source records are same as in target then execute first session or some rows are rejected due to t/r logic so session two was execute please clarify
How would you join a node to the already existing domain?
Plz..let me know differences between Informatica 7.1 and 8.1?
What do you understand by SOA of Informatica?
Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptno; Avg (sum (Sal)) o f all deptno= 9675 Deptno, sum (Sal) 10 8750 20 10875 30 9400
If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.
Teradata 
