Teradata API Stage

[muralisankarr]

We have a teradata API stage inserting records in to it.

On any run, it insert only the last row! Below is the log output

APITarget: Number of rows received = 20, rejected = 0, inserted = 1, updated = 0, deleted = 0

Is there any know issues we have in Teradata API stage. Please help

Many Thanks
MSR

[mgendy]

Simply the table is set table , not multi set , so it can't contain duplicates , and the 20 rows received must be 1 row duplicated 20 times , check this and feed us back

M.Gendy

[muralisankarr]

20 rows received must be 1 row duplicated 20 times
M.Gendy

No the rows are unique. The rows are not eliminated for that reason. My Non unique primary index(default as it is the first column) is employee_id and I have loaded 20 unique primary index records.

Please find the data snapshot below

100,Steven,King,SKING,515.123.4567,AD_PRES,24000,NULL,NULL,90
101,Neena,Kochhar,NKOCHAR,515.123.4568,AS_VP,17000,NULL,100,90
102,Lex,De Hann,LDEHAAN,515.123.4569,AD_VP,17000,NULL,100,90
103,Alexandar,Hunold,AHUNOLD,590.423.4567,IT_PROG,9000,102,60
104,Bruce,Ernst,BERNST,590.423.4568,IT_PROG,6000,NULL,103,60
107,Diana,Lorentz,DLORENTZ,590.423.5567,IT_PROG,4200,NULL,103,60
124,Kevin,Mourgos,KMURURGOS,650.123.5234,ST_MAN,5800,NULL,100,50
141,Trenna,Rajs,TRAJS,650.121.8009,ST_CLERK,3500,NULL,124,50
142,Curtis,Davies,CDAVIES,650.121.2994,ST_CLERK,3100,NULL,124,50
143,Randall,Matos,RMATOS,650.121.2874,ST_CLREK,2600,NULL,124,50
144,Peter,Vargas,PVARGAS,650.121.2004,ST_CLERK,2500,NULL,124,50
149,Eleni,Zlotkey,EZLOTKEY,011.44.1344.429018,SA_MAN,10500,0.2,100,80
174,Ellen,Abel,EABLE,011.44.1644.429267,SA_REP,11000,0.3,149,149,80
176,Jonathon,Taylor,JTAYLOR,011.44.1644.429265,SA_REP,8600,0.2,149,80
178,Kimberely,Grant,KGRANT,011.44.1644,SA_REP,7000,0.15,149,NULL
200,Jennifer,Whalen,JWHALEN,515.123.4444,AD_ASST,4400,NULL,101,10
201,Michael,Hartstein,MHARTSTE,515.123.5555,MK_MAN,13000,NULL,100,20
202,Pat,Fay,PFAY,603.123.6666,MK_REP,6000,NULL,201,20
205,Shelly,Higgins,SHIGGINS,515.123.8080,AC_MGR,12000,NULL,101,110
206,William,Gietz,WGIETZ,515.123.8181,AC_ACCOUNT,8300,NULL,205,110

[ArndW]

What column is the primary key defined as in Teradata?

[muralisankarr]

The syntax from SHOW Table is below

What column is the primary key defined as in Teradata

CREATE SET TABLE DEV01VHA.emps ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT
(
employee_id INTEGER NOT NULL,
first_name VARCHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC,
last_name VARCHAR(25) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,

email VARCHAR(25) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
phone_number VARCHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC,
job_id VARCHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
salary DECIMAL(8,2),
commission DECIMAL(2,2),
manager_id INTEGER,
department_id INTEGER)
PRIMARY INDEX ( employee_id );

[mgendy]

Does the table contains any previous data ? or it is empty ?

[muralisankarr]

Does the table contains any previous data ? or it is empty ?

It is a empty table

[muralisankarr]

Does the table contains any previous data ? or it is empty ?

It is a empty table

[anandsiva]

IBM has agreed this as a know bug and they are going to provide a patch for this issue.

[mgendy]

IBM has agreed this as a know bug and they are going to provide a patch for this issue.

could you please clarify where exactly is the bug ?

Regards