Help In Data Modeling Evarina Plz....

[aceruser]

hi ..


data modeling paina dbts unayi koncham help cheyagalara plz....

thanks......

[Silver_mani]

hi mama .... doubts ento ikka da veyyi .... telista chepta [img]http://i1249.photobucket.com/albums/hh517/twinklebt/brahmi-9.gif[/img]

[aceruser]

Source ni direct ga dimension la use cheyakudadu kada....
kani naa source nundi konni columns direct ga use chesthunnaru fact table loki measure la...
so nenu source ki similar dimension table ni use cheyocha?

naaku 3 type of reports unnayi based on 2 parameters. (okati date, inkoti location (county or state))
So nenu 3 fact tables create cheskovacha?
parameters ki date dimension, county dimension and state dimension vasthayi kada?

ikkada naaku 3 fact tables ki more or less same dimensions vaduthunna..
so oka data model la unchocha leda 3 diff report types kabati 3 veruga undala?


ivi na dbts ... thanks silver_mani

[Silver_mani]

[color=#282828][font=helvetica, arial, sans-serif]for above mentioned condition . I ll create only 1 fact table for all 3 reports ...[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]fact table= ur table which supports reports[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]Dimension1: time dimension[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]Dimension 2 : Location dimension (what ever location . country,state etc[b]u can add them as attributes in dimension , but not as a new dimension [/b])......and so on ...nee reports ni batti inka dimensions create cheskovacchu[/font][/color]


[color=#282828][font=helvetica, arial, sans-serif]source ni dimension ga vadatam enti ? naaku artham kaledu ...[/font][/color]

[Silver_mani]

[color=#282828]
k artham ayyindi ... source nunchi direct ga fact lo pedithe [b]avi DIMENSIONS avvavu [/b]...they are called TRANSACTION IDENTIFIERS[/color]

[Silver_mani]

calling Data modelling guys

[ManOnFire]