1.

What Junk Dimension Contains?

Answer»

It contains the miscellaneous ATTRIBUTES such as flags , which does belong to the main dimension table.

for eg; In a sales order fact table ,some informations LIKE, web-order , whether this is a ONLINE order or not new_cust , Is this PERSON a new CUSTOMER ?
verification , whether the order has been verified?

It contains the miscellaneous attributes such as flags , which does belong to the main dimension table.

for eg; In a sales order fact table ,some informations like, web-order , whether this is a online order or not new_cust , Is this person a new customer ?
verification , whether the order has been verified?



Discussion

No Comment Found