Skip to Content
0
Former Member
Jun 27, 2016 at 11:13 AM

Loading data from Flat file to Staging table

117 Views

Hi ,

what is the best way in BODS to load bulk data from flat file to staging table in very less time?.

I am using Flat File--->Query--->Staging table in Job with bulk load option checked,Source file has 83 Column and 3 millions records its taking 15 min to load the data.

Any other suggestion for this?.

Thanks-

Amit