Teradata Connector Error

shravya346 · Post by **shravya346** » Tue Dec 13, 2011 5:47 pm

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 .

nagarjuna · Post by **nagarjuna** » Tue Dec 13, 2011 5:51 pm

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 ?

shravya346 · Post by **shravya346** » Tue Dec 13, 2011 5:55 pm

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

nagarjuna · Post by **nagarjuna** » Tue Dec 13, 2011 10:37 pm

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