DSXchange

I am trying to load from oracle to Teradata:

Oracle Connector-->Copy-->TD Connector

I have created the target table as multiset and i am loading it ,
Access Method :Bulk


Even tough i have created the table as multiset , it is ignoring the duplicates and not loading them into the target .

Error:Number of rows skipped and duplicate rows ignored: 1,405


Have anyone face this error before , I have to load all the values from oracle to TD , do you have any suggestions on how this can be done .

What type of load you are using ? Is it a fastload or multiload ? If it is a fast load you can't load duplicates even it is a multiset table .

Do you have any unique primary or unique secondary indices ?

How do i determine what utility is being invoked by TD connector stage .

The options i am using are :
Access Method- Bulk
Write Mode - Insert
Table action : Append

Regarding the primary index : Yes

I have a primary index defined on a column .

Its not unique primary index

What type of load you are using ?? Load , update , stream ??