Using Views for Data Marts and Data Lineage

[system]

All,

We’re about to embark on a new data warehouse using SAP DataServices 4 and Information Steward. One design point we’re debating is whether to use database views to create our data marts or use physical data marts and use ETL to load data from our 3NF historical data store (HDS) to the data marts.

Our database is Teradata and we’ve low volumes of data so we’re not too worried about performance. The Teradata guys on the project are saying we should us views but my concern is that if we do we’ll loose our data lineage between the HDS and the data marts.

Has anyone been here before or know that this will be an issue?

Thanks

AL

---

agulland (BOB member since 2004-03-17)

[system]

if you are using IS, then you could run the RDBMS Intergator to collecte the lineage of the view (tables on which this view is created), and run the DS Integrator to get the end-to-end lineage from source table to view and from view to the target

---

manoj_d (BOB member since 2009-01-02)