Hi Tom,   Thanks for your answers. They have been very informative. Yes I got what you are trying to explain Tom. We will keep that in mind. Also, we are working on assigning weights to each metric. Thanks again for your answer!! ... View more

Hi LinusH, Yes we have our ETL designed in such a way that even if there are changes involved in layer 2 layer 3, the records go to the next layer with a message saying 'information modified' or something of that sort. But I am pretty sure that all the records move to the next layer unless there is some other unknown issue. I agree with you on the weights part. But I am not sure if we already have that in place. What would be the possible criterias to consider while giving a weight? I can think of a few like 1. Data usage(Is this data used?if yes by how many people?) 2. Criticality of the Data It would be great if you can add a few more aspects to be considered. ... View more

Hi Tom, Thanks for your prompt answer. This approach will be very useful to us. By Completeness i mean :   We have data load activity happening everyday. The data loaded movs through different layers/stages before being usable by the end user. Completeness means if there are the exact same number of records in all my layers/stages. for Ex: If layer1 has 1000 records, do layers 2 and 3 also have 1000 records? After going through the approach you have mentioned, I have a small clarification. If I have to report the health of my Datawarehouse on this day, how will I prioritize these above mentioned parameters and report on the same? i.e. if I have to construct a report which gives me the status of my datawarehouse, in what priority should I consider the parameters. Will Data Usability be the most weighted parameter? Awaiting your response. Shridhar Manvi ... View more