Join Index and Tpump

Tools & Utilities

Join Index and Tpump

Hi,

we have a informatica mapping which has two separate targets (firm dim and firm fact). We are using TPUMP update connection for updates.

We are first dropping the Join Index on the table and then carrying out the loads. we faced certain issues while loading the data without dropping the JI. is there any solution to resolve the issue?

Dropping JI, re creating JI is hampering our performance. any help in this regard is appreciated.

Thanks
Sumedh
1 REPLY
Enthusiast

Re: Join Index and Tpump

You can not update a column that's part of a Join Index using TPUMP.

Syed