I have the next situation, i need to load a flat file in a consecutive order to teradata, i mean in teradata i expect to see the records in the same order i had in the flat file
Column 1 column n
Record a 1
Record b 2
Record c 3
Record d 4
Record n n
Any idea and how can i do it ???
Thanks for any help
Add an IDENTITY column to the target table and load it via Fastload/MLoad.
When i tested this a few years ago the number was assigned exactly in input file sequence. I don't think this changed in later releases.
I tested using the next target table:
CREATE SET TABLE DD_STG_PNR.PRUEBA_TABLE
INC_COL INTEGER GENERATED BY DEFAULT AS IDENTITY
(START WITH 1
INCREMENT BY 1) ,
CADENA VARCHAR(10) NOT NULL
UNIQUE PRIMARY INDEX (INC_COL);
The flat file contains: 1,2,3,4,5,6,7,8,.......1 000 000
When i load this file using the fastload the result is
So, i have a problem 'cause i need the file in a sequence order :(
any other suggestion ??