qwerty1204 Posted March 5, 2012 Author Report Posted March 5, 2012 [quote name='Alexander' timestamp='1330991762' post='1301482875'] [img]http://lh6.ggpht.com/-Eoyjpy5n2PM/TnyuNWl4-OI/AAAAAAAAEWE/uc5DeoeG3_s/Brahmi-3.gif[/img][img]http://lh6.ggpht.com/-Eoyjpy5n2PM/TnyuNWl4-OI/AAAAAAAAEWE/uc5DeoeG3_s/Brahmi-3.gif[/img] [/quote] naa paristiti kudaa inthe baa [img]http://lh6.ggpht.com/-Eoyjpy5n2PM/TnyuNWl4-OI/AAAAAAAAEWE/uc5DeoeG3_s/Brahmi-3.gif[/img] ee madhya ee konchem learning
pavan_613 Posted March 6, 2012 Report Posted March 6, 2012 [quote name='CASANOVA' timestamp='1330991727' post='1301482871'] enni sarlu jumputhavu? [/quote] Single click three posts awesome hehe
qwerty1204 Posted March 6, 2012 Author Report Posted March 6, 2012 dala..pandemkodi..irritation..silvermani..inka DS meda evaru aite unnaroo andharu ee doubt explain cheyandi Dataware house --- Datamart OLAP --- OLTP --- ODS ee terms annitini kalipi oka example tho explain plzz
McDowellMurthy Posted March 7, 2012 Report Posted March 7, 2012 [quote name='arey ooo samba' timestamp='1331071195' post='1301486301'] dala..pandemkodi..irritation..silvermani..inka DS meda evaru aite unnaroo andharu ee doubt explain cheyandi Dataware house --- Datamart OLAP --- OLTP --- ODS ee terms annitini kalipi oka example tho explain plzz [/quote] Datawarehouse antey EDW mama...Datamart antey part of Datawarehouse which is used for Specific reporting purpose. Say Mottam Sales,Customers,Country undi anuko datawarehouse lo...then based on the requirement from the Users they need the specific reporting for Sales of few countries, then they disintegrate the data into Datamarts. OLAP antey manam Datawarehouse lo pettina tarvata jarige steps(Historical Data) OLTP antey everyday refresh avtundi data(bank transactions) ODS (Operational Data Storage) antey [color=#000000][font=Tahoma, Helvetica, sans-serif][size=3][left] ODS(Operational Data Source) is a integrated collection of related information . it contains maximum 90 days information.[/left][/size][/font][/color]
qwerty1204 Posted March 7, 2012 Author Report Posted March 7, 2012 [quote name='McDowellMurthy' timestamp='1331083234' post='1301486740'] Datawarehouse antey EDW mama...Datamart antey part of Datawarehouse which is used for Specific reporting purpose. Say Mottam Sales,Customers,Country undi anuko datawarehouse lo...then based on the requirement from the Users they need the specific reporting for Sales of few countries, then they disintegrate the data into Datamarts. OLAP antey manam Datawarehouse lo pettina tarvata jarige steps(Historical Data) OLTP antey everyday refresh avtundi data(bank transactions) ODS (Operational Data Storage) antey [left] ODS(Operational Data Source) is a integrated collection of related information . it contains maximum 90 days information.[/left] [/quote] thanx baa so data mart anedi...dataware house nunchi matramee build cheyagalamaa.. naa doubt enti ante..asalu dataware house ee ledu anukoo..can we initially create data marts and adding up all those data marts..will yiled a data ware house? datamart ki ODS ki diff enti baa..?
McDowellMurthy Posted March 7, 2012 Report Posted March 7, 2012 [quote name='arey ooo samba' timestamp='1331083734' post='1301486752'] thanx baa so data mart anedi...dataware house nunchi matramee build cheyagalamaa.. naa doubt enti ante..asalu dataware house ee ledu anukoo..can we initially create data marts and adding up all those data marts..will yiled a data ware house? datamart ki ODS ki diff enti baa..? [/quote] Data mart is a subset of a Data Warehouse with some additional data specific to that of the requirement. Datamart ki ODS ki difference idea ledu mama??!!
qwerty1204 Posted March 7, 2012 Author Report Posted March 7, 2012 [quote name='McDowellMurthy' timestamp='1331086144' post='1301486821'] Data mart is a subset of a Data Warehouse with some additional data specific to that of the requirement. Datamart ki ODS ki difference idea ledu mama??!! [/quote] no prob baa..thanx for the info
dalapathi Posted March 7, 2012 Report Posted March 7, 2012 facts dimensions antey emie ledhu........ oka tv showroom vaadi data vundanukoo........vaadu maanku dimensions facts annie files pamputhaadu.........first dimension tables load chestaav.....antey........colour, size, pixels, refresh rate itlaa ivannie dimensions annattu.......antey colour table lo anni colours vuntaayi black, red, green, size lo 32, 40, 42,50 inch atlaa.......pixels lo 720, 1080, refrsh rate table lo 60hz, 120hz ani vuntaayi......oka vela kottha dimension edaiana vastey..............vaadu aah data pamputaadu.........suppose.....vaalla TV lo 180hz vachindanukoo aah table lo load cheyyamani adhi pamputhaadu..... next fact file vachi....... transaction number, konnodi peru, tv number, colour, pixel, refresh rate, size 12345,Shyam, 4356, black, 720, 60,32 23132,Srujan, 4356, red,734,59, 40 23145,Anand, 2387, green, 1080, 132, 50 so, ippudu first dimensions load chesi......next fact file load chesetappudu.......ee dimensions valid ooh kaadho check chestaav(aah table meedha lookup chesi)..........1st record okkati valid kaabatti adhi pass chestaav........2nd daantlo pixel, refresh rate wrong, 3rd lo refrsh rate wrong kaabatti.......aah rendu records ni reject chesi endhuku chesinavoo oka error code ichi reject chestaav......atla reject chesina vaatini itla reject ayinayi ani palanaa vaadiki pampinchi solution kanukkuntaav..........veetini emi cheyyaalo............dhaanney erro handling antaav......
pavan_613 Posted March 7, 2012 Report Posted March 7, 2012 [img]http://i47.tinypic.com/4s086h.gif[/img]
dalapathi Posted March 7, 2012 Report Posted March 7, 2012 [quote name='arey ooo samba' timestamp='1331071195' post='1301486301'] dala..pandemkodi..irritation..silvermani..inka DS meda evaru aite unnaroo andharu ee doubt explain cheyandi Dataware house --- Datamart OLAP --- OLTP --- ODS ee terms annitini kalipi oka example tho explain plzz [/quote] datawarehouse antey.,........oka rakamgaa anni datamarts ni kalipithey datawarehouse anochu..... datamarts antey individual gaa finance vaadiki kaavaalsina data anthaa vuntadhi adhi financial datamart,.....marketing vaallaki sambandhinchina data vundedhi..........marketig datamart..........avannie vaallu idividual gaa reporting ki vaadu kuntaaru.............andari data theesukochi.........oka daantlo vestey adhey data warehouse anukuntaa........ olap antey......may be taruvaata check chesukodanaiki anukutnaa....may be warehouse laagaa.....oltp antey transactional processing antaaru kadaa.........may be credit card itla pettagaaney check chesi ventaney result ichevi oltp anukuntaa......... ods antey edho datawarehouse ki pampemundhu staging area ni antaaru kaavochu..........idhi assalu idea ledhu....
dalapathi Posted March 7, 2012 Report Posted March 7, 2012 [quote name='CITI' timestamp='1331088512' post='1301486875'] [img]http://i47.tinypic.com/4s086h.gif[/img] [/quote] [img]http://www.desigifs.com/sites/default/files/Bemmi%20(3).gif[/img][img]http://www.desigifs.com/sites/default/files/Bemmi%20(3).gif[/img][img]http://www.desigifs.com/sites/default/files/Bemmi%20(3).gif[/img]
Silver_mani Posted March 7, 2012 Report Posted March 7, 2012 SImple ga cheppalente Fact is a measure and Dimension is a Context
Silver_mani Posted March 7, 2012 Report Posted March 7, 2012 there are 2 popular ways to bulid datawarehouse .. Bill Inmon (Hub and Spoke Architecture)- a single HUB( datawarehouse) is connected to Spokes ( Datamarts)..so ikkada datamarts anni build chesi ... vatini integrate chestam with datawarehouse Ralph Kimball : there are no physical datamarts ...only logical grouping of subject Areas fron Datawarehouse which are treated as Datamarts for quick results ...Kimball appraoch chala famous .
Silver_mani Posted March 7, 2012 Report Posted March 7, 2012 [quote name='dalapathi' timestamp='1331088860' post='1301486883'] datawarehouse antey.,........oka rakamgaa anni datamarts ni kalipithey datawarehouse anochu..... datamarts antey individual gaa finance vaadiki kaavaalsina data anthaa vuntadhi adhi financial datamart,.....marketing vaallaki sambandhinchina data vundedhi..........marketig datamart..........avannie vaallu idividual gaa reporting ki vaadu kuntaaru.............andari data theesukochi.........oka daantlo vestey adhey data warehouse anukuntaa........ olap antey......may be taruvaata check chesukodanaiki anukutnaa....may be warehouse laagaa.....oltp antey transactional processing antaaru kadaa.........may be credit card itla pettagaaney check chesi ventaney result ichevi oltp anukuntaa......... ods antey edho datawarehouse ki pampemundhu staging area ni antaaru kaavochu..........idhi assalu idea ledhu.... [/quote] OLTP- for Bussiness purposes OlAP - for Analytical Purposes ( veeeti meeda Report Generate chestaru ) ODS(operational data source ) - its a copy of live data from the source ... So real time data ni touch cheyakunda dani replica (ODS) vadatam
pandemkodi Posted March 7, 2012 Report Posted March 7, 2012 [quote name='Silver_mani' timestamp='1331089768' post='1301486905'] OLTP- for Bussiness purposes OlAP - for Analytical Purposes ( veeeti meeda Report Generate chestaru ) ODS(operational data source ) -[b] its a copy of live data from the source[/b] ... So real time data ni touch cheyakunda dani replica (ODS) vadatam [/quote] idi correctey naa baa
Recommended Posts