Load Flag Update in staging table
Posted: Thu Nov 02, 2006 10:26 am
All,
I am loading the records from satging table into target table.I select the records from staging based on load_flag is null and process those records and load into target.After the process i want to update the load_flag in staging table to 'L' or 'F' i.e if the staging record succesfully inserted into target table then update the load_flag column for that record in staging table with 'L'..if record failed to insert into target table then 'F'.
Please suggest me the best way to do the above process.
Thanks in advance.
I am loading the records from satging table into target table.I select the records from staging based on load_flag is null and process those records and load into target.After the process i want to update the load_flag in staging table to 'L' or 'F' i.e if the staging record succesfully inserted into target table then update the load_flag column for that record in staging table with 'L'..if record failed to insert into target table then 'F'.
Please suggest me the best way to do the above process.
Thanks in advance.