On any run, it insert only the last row! Below is the log output
Is there any know issues we have in Teradata API stage. Please helpAPITarget: Number of rows received = 20, rejected = 0, inserted = 1, updated = 0, deleted = 0
Many Thanks
MSR
Moderators: chulett, rschirm, roy
Is there any know issues we have in Teradata API stage. Please helpAPITarget: Number of rows received = 20, rejected = 0, inserted = 1, updated = 0, deleted = 0
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.mgendy wrote: 20 rows received must be 1 row duplicated 20 times
M.Gendy
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 wrote:What column is the primary key defined as in TeradataSHOW TABLE emps; wrote: 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 );