Choosing the right Grain

Grain Types: Transactional :- Typically when I think of grain with respect to data, the beep at the cash register comes to mind. It defines the basis of that sales transaction. It can not get any more clearer! When the beep sounds, capture the time, product, quantity, price, counter, cash clerk, store, manager, and so on and you have all the details which define that line item in the sales transaction. Such a data capture is called data at transactional grain. Periodic snapshot:- Accumulating snapshot:- Sachin