The latest articles on DEV Community by neeraj kandwal (@neeraj_kandwal_26fe82143e). https://dev.to/neeraj_kandwal_26fe82143e https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F941420%2Fbe8f4bd8-527e-4d19-bd78-937c2ad689f1.png https://dev.to/neeraj_kandwal_26fe82143e en neeraj kandwal Sat, 15 Oct 2022 05:46:48 +0000 https://dev.to/neeraj_kandwal_26fe82143e/slowly-shifting-grain-vs-slowly-changing-dimension-23j8 https://dev.to/neeraj_kandwal_26fe82143e/slowly-shifting-grain-vs-slowly-changing-dimension-23j8 <p>My learned friend,</p> <p>Can someone please enlighten me about difference between slowly shifting grain V/S slowly changing dimension. I am sure they are not same. Grain refers to the lowest level of information stored in a fact is defined. For example for a sales transaction we can say the grain will be what product, which day, which store(location), what customer, what quantity. Can this ever drift or change slowly..?</p> <p>Slowly changing dimension is I know has three options</p> <p><strong>option 1</strong> where we simply overwrite the old attribute value with the new value. So no history is maintained.</p> <p><strong>option 2</strong> we insert a new row in dimension</p> <p><strong>option 3</strong> keep a pair of attributes to preserve the old and new value adding additional columns</p> <p><strong>BUT WHAT IS SLOWLY CHANGIN OR DRIFTNG GRAIN?</strong></p> datawarehouse neeraj kandwal Wed, 12 Oct 2022 04:15:46 +0000 https://dev.to/neeraj_kandwal_26fe82143e/what-does-slowly-shifting-grain-mean-5f6n https://dev.to/neeraj_kandwal_26fe82143e/what-does-slowly-shifting-grain-mean-5f6n <p>what does slowly shifting grain mean in terms of data ware house</p> datawarehouse