Informtica session load taking much time
Posted on 2009-05-03
I have a mapping which performs sqloveride in sourcequalifier and then route to expression transformation and from there route to 5 filter transformation to target table T1. The related session is taking 18 mins to load. I want to reduce overall load time.. I saw that sqloveride just take a second to execute and start loading to table so there is no source bottleneck. I have replaced 5 filter to single router transformation in mapping but no performance enhance .I think the bottleneck is at target table. I am performing update else insert in mapping. The target table t1 has 5 primary keys and each key has a unique index on it.The index is on following cols- acctg_date,prod_code,balbook_code,acct_code,center
_code. Can anyone please advise me on how can I tune target table to reduce the load time.
The target table t1 contain about 4.7 million records.Thanks