Dimension table does not hold data for every business transactions. Instead it hold the supporting attributes to those transactions. e.g. In a typical insurance business, if someone received a policy claim amount or pays for policy premium , record for that payment will not got to dimension table. It will be loaded into fact table. Dimension table will hold the details of who has paid for the policy or who has received a claim amount etc. I hope it should your clear your doubts.
hi i am nisar ahmad from afghanistan i used hindi language start hi ser ap quo ap hamko hindi me viduo bnado ki teree vedues bhot acha hi likin ap hinde be use kre pless
Thanks Vikram,it was helpful, where can I find next video in series?
what is the meaning *dimensional table are non transnational table*?
Dimension table does not hold data for every business transactions. Instead it hold the supporting attributes to those transactions. e.g. In a typical insurance business, if someone received a policy claim amount or pays for policy premium , record for that payment will not got to dimension table. It will be loaded into fact table. Dimension table will hold the details of who has paid for the policy or who has received a claim amount etc. I hope it should your clear your doubts.
yes sir, Thank you!
This one is good.
hi i am nisar ahmad from afghanistan i used hindi language start hi ser ap quo ap hamko hindi me viduo bnado ki teree vedues bhot acha hi likin ap hinde be use kre pless