I am having a requirement like this. Need to load the data from file to sales table, which dont have any additional index.
Can i load directly from file to table using MLOAD.
Or, can i load from file to staging table using FLOAD and then use Insert select to load the sales table.
Which one is better in terms of performance.
Please help !!!!
Thanks in advance.