6. Sample CSV File¶
Create a file named TEST_person_20240101_20240102061500.csv with the following content. The name matches the file name pattern of the sample loader: business date 2024-01-01, created on 2024-01-02 at 06:15:00.
ID;FirstName;LastName;Salary;BirthDate
001;Frank;Moses;5.000,00;19550319
002;Marvin;Boggs;4.500,00;19531209
003;Sarah;Ross;4.750,00;19640802
004;Ivan;Somanov;4.750,00;19460601
005;Joe;Matheson;4.750,00;19370601
The first row is the header, which is skipped (p_file_skip_rows = 1). The columns are separated by ‘;’, the salary uses ‘,’ as decimal and ‘.’ as thousands separator, and the birth date has the format YYYYMMDD.