Need help in loading the data through load data module?

ginjupalli · ‎06-14-2018

I have a Excel file which has around 250 K records I want to load these records in my instance. How can I achieve this?

What is the maximum limit of the records that we can load through the load data module?

nayanawadhiya1 · ‎06-14-2018

For importing does not have limit criteria but for exporting the records has limit criteria for that

Navigate to System Proerties -> Import Export

Excel sheet is 1,048,576 rows so excel sheet contains 250K records in multiple sheets.

And I don't think there is a limit. However as a best practice Break a very large data set into multiple, smaller jobs for faster results. Consider import sets under 100,000 records as a guideline. For example, importing 10 sets of 100,000 records completes faster than one import of 1 million records even though the total data imported is the same.

View solution in original post

nayanawadhiya1 · ‎06-14-2018

You want to check which is inserted, updated and ignored during Run Transform then you can check it into temporary Table by the help of STATE field and Error as well.