Hello, We are migrating the data from SQL Server to Hp Vertica. When we created the tables in Vertica we have renamed the tables along with their custom column names to more sensible naming conventions. For Example the table PPS_Group has been renamed as DIM_Group (Group is a dimension table). And t...

Thanks Nnani for your reply.

Thanks Jim for your reply.

Hello,

Vertica will allow to load the same data file into table any number of time and it will create duplicate rows.

Is there any way to handle this duplicates ??

While data loading if some rows goes to error then what is the best way to handle it?

Thanks in advance.

Hello,

I am migrating some tables from oracle to vertica and i have some less than constraints created on some columns in oracle(for e.g CONSTRAINT "EMP_SALARY_MIN" CHECK (salary > 0) ENABLE,).

How I can add same constraint in vertica while creating the table ?

Thanks-