All Forums General
gowmi05 2 posts Joined 06/13
11 Dec 2013
Fastload Error Table 2

Hi all,
 I have tired to load the data into target table having UPI using Fastload.While loading Duplicate value for UPI is captured in Error Table, Error table 2 is not dropped but fastload terminated with Return code 0.
please suggest me how to fix uniqueness violation error .

M.Saeed Khurram 544 posts Joined 09/12
11 Dec 2013

when the fastload receives duplicate values for the UPI, it inserts the UPI violation rows into error table. this error table is created each time, but dropped only if there is no UPI violations. Since you hve UPI violations, so the table will contain all the violated rows.
To avoid this unique violation error, if you have to retain duplicate values, convert the PI to NUPI, and also the Table to Mutliset.


Raja_KT 1246 posts Joined 07/09
12 Dec 2013

Even you can try with NOPI tables as staging, it can be faster and then load to target table .

Raja K Thaw
My wiki:
Street Children suffer not by their fault. We can help them if we want.

You must sign in to leave a comment.