Hi I need to develop an application which reads a csv file from a server does data validation and write to a file and then bulk upload the data to an Oracle database.
The details of the requirement is
The input csv file contains data that has to be populated to the database. Currently i have the schema of the tables that has to go into the ORACLE DB but data on the input csv file is not yet finalized.
So the application(prefer JAVA) has to rbe generic and has to read a config file to do the mapping(which field on the input csv file has to map to which filed n the output table schema)
Regarding the way to populate the DB, the decision is to use SQL loader. The volume of data to be uploaded is also huge.
Need help on the factors which need to be taken care while developing this application.