Team,
I am looking for few techniques/approach to follow if we have Source Data or Meta Data , lets say we have 10 source tables and where i need to load it to target.
What are steps that one need to follow in terms for analyzing source the data, I know that I am not giving you source tables which actually does not make sense to ask question here.
Somehow like- Identifying the critical source Data elements. find Data Duplicates, find bad data, Apply Anamolie techniques for finding what the issue in source data is.