Datawarehouse architecture - Error Tables RRS feed

  • General discussion

  • Hi Experts,

    Could you please provide your thoughts on creating error tables while doing datawarehouse design?

    I am suggesting 2 approaches here. Please let me know your thoughts and educate me if there is any standard practice if any.

    1. Maintaining a single error table for the whole project with columns Error desc and Key fields as 2 of many columns. so table level error can be identified by a unique key for each package and so on.

    2. Maintaining individual error tables for each dimension tables. ie we will maintain a separate error table for each dimension table with error description as one of the column.

    Please let me know what would be the merits and demerits of having these two approaches.



    Tuesday, April 1, 2014 12:11 PM