1. Do not use your logic and do not trust their logic, just do the data conversion.
2. Client may need to add more data after the data conversion. So, think of this feature from your first steps otherwise you may forced to do all the process again.
3. Frequently check new data with old ones.
4. Use multi-threading programming.
5. Handle exceptions, NULL/unformatted DataTime and extra white spaces.
6. Don’t forget to do date and Farsi conversion (convert all Arabic character to Farsi, e.g. ي to ی or other characters). Of course if are working on a Farsi database.
7. Log everything. This will also help you to make report at of the project.
Don't know what is ETL?! Check Wikipedia: Extract, transform, load
0 comments:
Post a Comment