Hi Leopoldo,
The most I've imported via flat file is 4 million rows. It took about 35 seconds to load so the load times are very quick. I'm not aware of any limits on the size for a flat file load.
Regards,
Gary
Hi,
I have tried to load the around 5 million record thorugh the flat file. It took less than one minute to load the data into SAP HANA. Now aware about the limit of the file size.
Regards,
Neha
Hi Neha,
Do you mind to share your code on how to load 5million records of flatfile in abap program?
Thank you.
Regards,
Kelvin
Many thanks for your answer.
Just to have some more details, how big were your flat files, and how much time did you spend to generate them on the source system and to copy them on HANA Server?
PS
Import times are simply fantastic!
Hi,
Actually size of the file is depend on the number of the coulmns in the flat file.
For example: I load the file having the 1 million record with 50 columns.
The size of the file is around 150 MB and it took less than 5 minutes to copy the file into server.
Regards,
Neha Singla
