Hello, I am creating a table cust_shipment with column name as name and id which is auto gnerated. now i want to insert 100 records. my question is that since terradata works on MPP. does each record get a unique id or like 10 records are inserting at once so these 10 records get same id. plz suggest a way out.
Using Generated Always will guarentee 'unique' rows but does not prevent 'duplicate' rows - i.e. rows that are duplicate from the source but are loaded with a unique ID. You will need to factor this into your design. There are limitation of Identity columns - replication etc. There are other methods of generating a unique value that should be inestigated. You should have a good read of the Data Definition reference.