We have a requirement to upload data into staging table (View) for different file types provided by client.
We are planning to handle this UPLOAD dynamically for all the file types like Target table will be same for all the types but columns will change using DATA LOAD Wizard.
Based on the file type, APEX has a intelligence to do mapping of columns and insert data into View table. We need clarifications on the above requirement and requesting your suggestions on the same.