briangriffin
Programmer
I've started getting a flat file each day of all employees and the usual HR data - not a lot, about 700 employees and 20 fields. Every employee is in the file every day.
Right now I'm working on the ETL piece to get it all into a table, and I think I'll store all the data each day for auditing purposes. Ultimately I need to produce a file each day of any new employees (no problem there) but also any employee where any piece of data has changed from the previous day. I can pull everything out of the history table directly into the report, or I could load those changed records into another table to make the reporting piece a snap.
This is a classic type of request so before I start lumbering through it I thought I'd get some advice on the best approach from people who have done it before. Thanks in advance.
Right now I'm working on the ETL piece to get it all into a table, and I think I'll store all the data each day for auditing purposes. Ultimately I need to produce a file each day of any new employees (no problem there) but also any employee where any piece of data has changed from the previous day. I can pull everything out of the history table directly into the report, or I could load those changed records into another table to make the reporting piece a snap.
This is a classic type of request so before I start lumbering through it I thought I'd get some advice on the best approach from people who have done it before. Thanks in advance.