Ask Your Question

Revision history [back]

In general, it's better to have the database manage these kind of id columns. Here is an example from StackOverflow of how to define an auto-increment column in Teradata:

SEQ_NUM decimal(10,0) NOT NULL GENERATED ALWAYS AS IDENTITY
           (START WITH 1 
            INCREMENT BY 1 
            MINVALUE 1 
            MAXVALUE 2147483647 
            NO CYCLE)

If you really must have the value generated in Data Collector, Dash's suggestion of a UUID is the best way to go. Generating sequential record id's in the pipeline is tricky and brittle.