I have a requirement to compare data from .csv file which is the source to a target oracle table. I have multiple files/tables and I need a unique job for all. I tried using dynamic schema but it’s not working. Can someone suggest a better way.
I'm afraid it is impossible to compare data through tMap using dynamic schema for different files with different structure. My idea is to read the files using dynamic schema, create the corresponding table in Oracle DB and then compare the rows between two tables using SQL query.
