SCD type 2, close record without new records inserted

DWH-M · Post by **DWH-M** » Thu May 14, 2009 3:08 am

Hi ,

I was looking for the methodology where in when in a retail store dimensional data of various offers is managed. if at a particular time if all the offers are finished and there exists no offer then can we go ahead and close the end date? is there any side effects to do so?

ray.wurlod · Post by **ray.wurlod** » Thu May 14, 2009 4:33 pm

Your question is too vague? WHICH end date? The end date of the offer period, certainly. Any other end date, doubtful.

DWH-M · Post by **DWH-M** » Fri May 15, 2009 3:08 am

Ray - what I mean is, is it ok to have all the records closed without any open records?

chulett · Post by **chulett** » Fri May 15, 2009 6:44 am

How can anyone other that you and yours answer that question with anything other than "depends"? Ask whomever is responsible for the design of that table.