Metadata requirements for developers
- by Paul James
I'm tasked with providing a list of metadata requirements our data warehouse developers might need.
This is not the business metadata (nice descriptions etc), but rather data required for change management (also known as impact assesment), data lineage etc.
I've seen this article Meta Meta Data Data - Ralph Kimball but as I'm not the first person to do this I'm throwing it to the SO community.
The actual question is this:
What metadata do datawarehouse developers require to design, develop and manage change in ETL routines?
PS: I'm trying to keep the answer platform agnostic but for context this is an Oracle database with PL/SQL and Datastage.