Author Topic: Uploading CSV file takes a long time  (Read 226 times)

Offline therese1

  • Full Member
  • ***
  • Join Date: Jul 2017
  • Posts: 21
  • Forum Citizenship: +0/-0
Uploading CSV file takes a long time
« on: 17 Oct 2017 04:00:56 am »
Hi I am just checking on an issue I am having with our vendor in loading 4gb csv file in backend of cognos.

They are saying they cannot load a file that big it keeps coming up in error... would this be true?

I have split the csv into 41 mini files each around 80MB they are now saying it takes 20minutes to load each file?

Sorry I am not a backend expert but I thought if they create a table in DW from sample data they should be able to quickly load any bigger files?

Another question would it be quicker if I split files to under 100MB load from front end, link to data module and they can take these files to make back end server data (one package)?