rationale behind dimension with Type 0 and missing Type 5

Can anyone explain in detail on what is the rationale behind having the dimension start with Type 0 and also for the missing type 5

I don't know what you are talking about. Can you rephrase the question?

I meant on what different scenarios, a Type 0 SCD technique is used? Also why is that there is no type 5 SCD technique?

Type 0 is only useful for static data which will not change once it is inserted into the DW. An example could be an Insurance data warehosue model which has an accident type dimension..., or just about any static data the architect/modeller has chosen to store as a dimension in the DW. Once it is entered, the data is never updated. There are only inserts of new data. I personally don't see the usefulness for this SCD type because even static data doesn't remain static forever.

I don't know why there isnt a Type 5 SCD but there is a Type 6 which is derived from a mix of types 1+2+3. I guess if you can think of a situation that requires a mix of types 1+4 or types 2+3 then you can call that type 5.

Good luck!

I only understand and model type 1,2, and 3 dimensions. I've never needed anything else.

rademola wrote:Type 0 is only useful for static data which will not change once it
I don't know why there isnt a Type 5 SCD but there is a Type 6 which is derived from a mix of types 1+2+3. I guess if you can think of a situation that requires a mix of types 1+4 or types 2+3 then you can call that type 5.

Good luck!

Oy! Of course, if you use expotentiation, a mix of type 2 and 3 would be a type 8 (2^3) or a type 9 (3^2) depending on your point of view. If you sometimes do different then you need to multiply by pi. So a mix of 2 & 3 that sometimes is treated as a 1 would be a type 25.13272 or a 28.27431.

Most people stick to 1, 2, and 3. I usually refer to columns being type 1 or type 2. It's not uncommon for a dimension table to have a mixture of 1 and 2.

[/quote]
Oy! Of course, if you use expotentiation, a mix of type 2 and 3 would be a type 8 (2^3) or a type 9 (3^2) depending on your point of view. If you sometimes do different then you need to multiply by pi. So a mix of 2 & 3 that sometimes is treated as a 1 would be a type 25.13272 or a 28.27431.
[/quote]

I dont think so...

Types 1,2 and 3 is what I have ever used (and in some cases I deviate from what the books say and end up with what works!).

Borders on the esoteric/academic what I explained and I did so because priyagan07 asked.

Multiply by pi, common!

Thanks all for your comments. It was quite informative