One major difference between the types of system is that data warehouses are not
usually in third normal form (3NF), a type of data normalization common in OLTP
environments.
Following figure illustrates key differences between an OLTP system and a data
warehouse.
usually in third normal form (3NF), a type of data normalization common in OLTP
environments.
Following figure illustrates key differences between an OLTP system and a data
warehouse.

Thanks for great information you write it very clean. I am very lucky to get this tips from you
ReplyDeleteRefrigerated transportation Canada