Describe the meaning of the term data mapping.
By definition, the term data mapping is the process by which a system developer creates data element mappings that relates two models of data (databases) in order to assist in data integration. This usually assists in the following manner:
i) Data mediation or transformation between the source and the destination of data
ii) Assisting in data lineage analysis by identifying the data relationships
iii) Assists in data masking by discovering sensitive data
iv) Assists in data de-identification process
v) Assists in consolidating multiple databases into one thus identification of redundant columns and advising the developers for consideration or even elimination.