i need to import huge tables (40.000.000 records) into an HANA system, in order to develop a demo system for a customer.
I'm planning to use CSV files.
Does someone have experience in a task like this? is there a limit to CSV file dimension?
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.
As per my knowledge .csv file (any flat file) do not have any limitataions. The main thing is depends on the database from where you are fetching data. In R/3 perspective it will allows you to extract upto 1billion records into a single flat file.
Check out this blog for best practice to load high volume data from flat files: