1. Initial data load with proper connection strings.
2. Load individual tables, then Join/Concatenate/Mapping/Keep based on data, fields.
3. Clear most of the Synthetic keys to make tables are Clear
4. Follow renaming, alias, Qualify, UnQualify to make tables as independent.
5. Create / translate coded values.
6. Follow naming standards, Code updates (Add comments to identify modifications easily)
7. Deriving new fields by Data aggregations.
8. Unit test on data accuracy.
9. Debug script for data load.
10. Create loops to update, instead of more script creation.
11. Sequence generation with different functions to avoid data loss.
12. Follow these steps to n no.of times to avoid other issues.
Then better data model created.
