aceruser Posted May 9, 2012 Report Share Posted May 9, 2012 hi .. data modeling paina dbts unayi koncham help cheyagalara plz.... thanks...... Quote Link to comment Share on other sites More sharing options...
Silver_mani Posted May 9, 2012 Report Share Posted May 9, 2012 hi mama .... doubts ento ikka da veyyi .... telista chepta [img]http://i1249.photobucket.com/albums/hh517/twinklebt/brahmi-9.gif[/img] Quote Link to comment Share on other sites More sharing options...
aceruser Posted May 9, 2012 Author Report Share Posted May 9, 2012 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 Quote Link to comment Share on other sites More sharing options...
Silver_mani Posted May 10, 2012 Report Share Posted May 10, 2012 [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] Quote Link to comment Share on other sites More sharing options...
Silver_mani Posted May 10, 2012 Report Share Posted May 10, 2012 [color=#282828] k artham ayyindi ... source nunchi direct ga fact lo pedithe [b]avi DIMENSIONS avvavu [/b]...they are called TRANSACTION IDENTIFIERS[/color] Quote Link to comment Share on other sites More sharing options...
Silver_mani Posted May 10, 2012 Report Share Posted May 10, 2012 calling Data modelling guys Quote Link to comment Share on other sites More sharing options...
ManOnFire Posted July 20, 2012 Report Share Posted July 20, 2012 Quote Link to comment Share on other sites More sharing options...
.thumb.gif.343fe49c7e1c507ae0056326bd8cf77e.gif)
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.