Part of data governance is not only modeling entities, but in data ware house you have multiple layers, which do kind of data transformation/normalization.
Is there any best way how to document these kind of processes on attribute entity level?
Usual task is:
- apply function on data attribute
- map single field from source model to target model
- map multiple fields from source to target model and vice versa
- lookup to external data source
So its about design of ETL task
I am quite stuck in this area about how to utilize VP in best way to document this model lineage transition.
Thank you for any response.
I am now evaluating VP for this task before obtaining license.