We have fixed width file having 50 columns and planning to load the data as is into a table having similar structure. The size of the file would be 8-10 GB. What would be efficient ways to load the table?
What is your definition of "efficient" ?
First of all, Thank you so much for responding to the question. What i meant by efficient is the best and fastest ways to load the data.
Still qualitative :-) What metric measures "best and fastest" ? Loading 1 million rows per sec ? per min ? per hour ? per day ?