Please help me with below scenario.
I have data in flat file : Employee status
10 Sabbatical leave
I have to insert data into table using employee table and employee status file
INSERT INTO TABLE A
<should read from file>
While inserting data into table A , Employee table has status ID, we should fetch status from file, based on matching ID from employee
You will find loading your file into a staging table and then using it and employee to load table A will work.