Metadata requirements for developers

Posted by Paul James on Stack Overflow See other posts from Stack Overflow or by Paul James
Published on 2010-03-30T13:35:07Z Indexed on 2010/03/31 6:33 UTC
Read the original article Hit count: 307

Filed under:

metadata

|

datawarehousing

|

data-warehouse

|

Requirements

|

database

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.

© Stack Overflow or respective owner

Related posts about metadata

Storing SCA Metadata in the Oracle Metadata Services Repository by Nicolás Fonnegra Martinez and Markus Lohn

as seen on Oracle Blogs - Search for 'Oracle Blogs'
The advantages of using the Oracle Metadata Services Repository as a central storage for the metadata. SCA has been available since the release of the Oracle SOA Suite 11g. This technology combines and orchestrates several SOA components inside an SCA composite, making design, development… >>> More
Logical Domain Modeling Made Simple

as seen on Oracle Blogs - Search for 'Oracle Blogs'
How can logical domain modeling be made simple and collaborative? Many non-technical end-users, managers and business domain experts find it difficult to understand the visual models offered by many UML tools. This creates trouble in capturing and verifying the information that goes into a logical… >>> More
Error starting modern compiler

as seen on Stack Overflow - Search for 'Stack Overflow'
In my servlet , I m using Tomcat 5.0 and JRE is 1.5.0 but it is giving error when I click on the URL . As when I created a war file of my project and deployed in tomcat than it is working fine . It means that only problem with my eclipse configuration ERROR IS : - Apr 5, 2010 3:20:22 PM org.apache… >>> More
How to remove Thumbnail property of a JPEG image without distrubing other Exif data in C ++ .net.

as seen on Stack Overflow - Search for 'Stack Overflow'
I have an application which edits the metadata part of the JPEG image. I have to remove the thumbnail metadata with out disturbing other metadata. I have tried out the code below but was not successful in removing thumbnail metadata. can some help me out in solving this query thanks in advance. array<String^>^… >>> More
Ask Tom: "On Constraints, Metadata, and Truth"

as seen on Oracle Technology Network - Search for 'Oracle Technology Network'
Our technologist uses constraints to improve query performance. >>> More

Related posts about datawarehousing

Tech Article: Using Oracle GoldenGate for Real-Time Data Integration

as seen on Oracle Technology Network - Search for 'Oracle Technology Network'
Learn how to install, set up, and configure Oracle GoldenGate to easily achieve seamless replication of data between Oracle Database 10g and 11g. >>> More
Tech Article: Oracle Essbase Studio Deep-Dive

as seen on Oracle Technology Network - Search for 'Oracle Technology Network'
Dive into a step-by-step tutorial that reflects real-world data warehousing complexities. >>> More
Finding the maximum value/date across columns

as seen on SQL Blogcasts - Search for 'SQL Blogcasts'
While working on some code recently I discovered a neat little trick to find the maximum value across several columns….. So the starting point was finding the maximum date across several related tables and storing the maximum value against an aggregated record. Here's the sample setup code:… >>> More
Insert into a star-schema

as seen on Stack Overflow - Search for 'Stack Overflow'
I've read a lot about star-schema's, about fact/deminsion tables, select statements to quickly report data, however the matter of data entry into a star-schema seems aloof to me. How does one "theoretically" enter data into a star-schema db? while maintaining the fact table. Is a series of INSERT… >>> More
What is the best FREE solution to implement one ETL project in MySql

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, What is the best FREE solution to implement one ETL project in MySql? Regards, Pedro >>> More