I have created a table like this :
Code: Select all
CREATE TABLE public.DIM_PAYS_TEST (
CODE varchar(3) NOT NULL,
CODE_NUM int NOT NULL,
ALPHA2 varchar(2) NOT NULL,
ALPHA3 varchar(3) NOT NULL,
LIBELLE_FR varchar(100) NOT NULL,
LIBELLE_EN varchar(100) NOT NULL,
CONSTRAINT PK_DIM_PAYS_TEST PRIMARY KEY (CODE_NUM) ENABLED
)
UNSEGMENTED ALL NODES
KSAFE 1 ;
When I try to load the same data again using an ETL tool like SAP BusinessObject Data Services (ODBC) or Talend (JDBC), the data are loaded and therefore duplicated even if the constraint is enabled. But if I try a simple
Code: Select all
INSERT INTO public.DIM_PAYS_TEST (CODE,CODE_NUM,ALPHA2,ALPHA3,LIBELLE_FR,LIBELLE_EN) VALUES ('894','894'::Integer,'ZM','ZMB','Zambie','Zambia') ;
How come the PK is not reinforced with the ETL tools, is there a connection parameter to add in the client configuration ?