Devising a changed data capture method is up to the development team. The ETL tool has no method for this per se. If someone knows how to set this up, can we have step by step instructions. It has been determined that we cannot use a source file located on the LAN or hard drive. We need access.
Security is an issue with HR data.
I selected Notepad the first time and it is not going to work. I can't seem to find where I can change to write. Data Administration will also be available to communicate and explain the standards and best practices. A great deal off interaction between the project and Data Administration is essential. For validation purposes it would be helpful to be able to return the database to its original status after any data manipulations so that we can validate with original baseline queries.