Hello Guru's,
We have transactional data in a source database. And we are loading this data into staging tables of data warehouse environment. We get this transactional data in a flat file and we are using SQL *loader to load the data into staging tables.
The source tables(Transactional) have some constraints like primary key and Unique key or NOT NULL constraints. And we are creating the same tables in staging area(DW environment) as in source database(transactional environment) in order to just dump the data in staging area as it is in the source database(transactional)
So my question is
- Do we need to create the constraints for staging tables(DW enivronment) as it is in the
Source DB tables(Transactional environment) Like Not NULL/ Primary Key /Unique Key constraints ?
- Or either just create the tables in staging without any constraints ?
What do guys suggest? . And, Just Fyi..We have another schema,
we ill be moving data from staging to Reporting schema,
And there, we are planning to have constraints on this tables.
So i would like to know the best practice from a data warehousing stand point. ? Any advice is greatly appriciated!
Thank you so much!
Edited by: user642297 on Feb 3, 2011 7:43 PM