Hi , I want to write a sql query to check the data loaded into interface tables land in correct columns. We are loading huge data thrugh SQL Loader Oracle Table , all the data are getting loaded properly but after the load datas are getting loaded in wrong columns e.g in the data file we have data data of country and .ctl we have proper maping for country but after the country date is being loaded to county field in the database table. For this reason we want to Prepare sql queries to check the data loaded into the tables land in correct columns .Can anyone please help on this .
Thanks,
Mike