| Author |
Message |
    
2007
Bewarse
Username: 2007
Post Number: 1456
Registered: 05-2006
Posted From: 136.182.2.221
| | Posted on Thursday, August 24, 2006 - 4:16 pm: |    |
MAMA maa BRM tho matladali ante protocols danemma ademanna pedda george bush gadi pellam ayinattu benali di... mana desi gallaki intha EGO endi mama... suntagallaki.. chi denemma...  |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 27216
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Thursday, August 24, 2006 - 3:44 pm: | |
 vaadi meedha eppudo suddengaa enaka nundi burkha esi D'gi kummeyyi maama...doola theeripovaala...
A friend to all is a friend to none  |
2007
Bewarse
Username: 2007
Post Number: 1452
Registered: 05-2006
Posted From: 129.188.33.222
| | Posted on Thursday, August 24, 2006 - 3:41 pm: | |
GOCI mama ekkuthavule.. oorike edavakau 
ee thuraka user gadu vademma vade rqmts ichhindi ippudu idela vachhindi ante.. Guddxa pagala dengali EP gallani.. ee thurakollaki s/w endulo.. guttallo thepakulu pattukuni gaddam penchukuni thiragaka..thuraka LK gallu |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 27214
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Thursday, August 24, 2006 - 3:37 pm: | |
ettagotta ee project gattekkithe saalu devudaa...
A friend to all is a friend to none |
2007
Bewarse
Username: 2007
Post Number: 1451
Registered: 05-2006
Posted From: 129.188.33.222
| | Posted on Thursday, August 24, 2006 - 3:35 pm: | |
nadi daily mama.. idi DWH naa naa M.. data migration idi.. ee motorola M gallaki mind vuntenega.. mana desi gallele idi design chesindi.. M laga design chesaru sollu gallu... chal phat.. nenu 6 le work chesthundi.. nenu singapore lo project chesa.. adi denemma DWH ante.. |
Bob
Vooriki Bewarse
Username: Bob
Post Number: 5239
Registered: 03-2005
Posted From: 68.0.67.119
| | Posted on Thursday, August 24, 2006 - 3:33 pm: | |
nayakudu ,nuvvu informatica lo work chestunava e version ,7 aa 6?
nidi etl frequency enti?
Do Me a Favour "Let's PLay HOli" Rang mE hi PYaar ga GHOli
|
2007
Bewarse
Username: 2007
Post Number: 1450
Registered: 05-2006
Posted From: 129.188.33.222
| | Posted on Thursday, August 24, 2006 - 3:32 pm: | |
manchi experience mama.. neeve nerchukuntavu.. ila vundali asala DWH ante.. first users daggaraku velli anni adgu.. thruvatha book avuthavu.. madathadi poddi  |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 27212
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Thursday, August 24, 2006 - 3:31 pm: | |
ento deenamma eppudu nenu designlo work cheyyaledhu maama...report requirement isthe query raasevodni...ippudu ivanni dobbicchukovaalante vats pack avuthunnaayi
A friend to all is a friend to none |
2007
Bewarse
Username: 2007
Post Number: 1448
Registered: 05-2006
Posted From: 129.188.33.222
| | Posted on Thursday, August 24, 2006 - 3:29 pm: | |
correct datamart lo historical data at month level pettuko..  |
2007
Bewarse
Username: 2007
Post Number: 1447
Registered: 05-2006
Posted From: 129.188.33.222
| | Posted on Thursday, August 24, 2006 - 3:28 pm: | |
adi GOSI chepthaduu |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 27211
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Thursday, August 24, 2006 - 3:28 pm: | |
store the histoical data in datamart.. what will be frequency of ETL run... daily/weekly/monthly
maama daily reports unnayi...kaani history ni use chesevi mostly monthly...so histrical data anthaa monthly ettukunte betteremo....
bobesh..emani seppanu naa kattalu  G moosukuni SAS nerchukovaali
A friend to all is a friend to none |
Bob
Vooriki Bewarse
Username: Bob
Post Number: 5238
Registered: 03-2005
Posted From: 68.0.67.119
| | Posted on Thursday, August 24, 2006 - 3:28 pm: | |
frequency of etl may depend on company's amount of data..daily/weekly/monthly...
Do Me a Favour "Let's PLay HOli" Rang mE hi PYaar ga GHOli
|
2007
Bewarse
Username: 2007
Post Number: 1446
Registered: 05-2006
Posted From: 129.188.33.222
| | Posted on Thursday, August 24, 2006 - 3:27 pm: | |
and how frequently users run the reports.. |
Bob
Vooriki Bewarse
Username: Bob
Post Number: 5236
Registered: 03-2005
Posted From: 68.0.67.119
| | Posted on Thursday, August 24, 2006 - 3:26 pm: | |
vorni gochi mama eppudu nuvvu sas nerchukovala..
Do Me a Favour "Let's PLay HOli" Rang mE hi PYaar ga GHOli
|
2007
Bewarse
Username: 2007
Post Number: 1445
Registered: 05-2006
Posted From: 129.188.33.222
| | Posted on Thursday, August 24, 2006 - 3:25 pm: | |
store the histoical data in datamart.. what will be frequency of ETL run... daily/weekly/monthly?? |
Bob
Vooriki Bewarse
Username: Bob
Post Number: 5235
Registered: 03-2005
Posted From: 68.0.67.119
| | Posted on Thursday, August 24, 2006 - 3:24 pm: | |
datamart is a subset of dwh, suppose company lo different sections unnayei x,y,z.. with datamart you store the info of a particular segment in a place [x] so that it becomes easy to retreive the data from a single consolidated place rather from a whole entity.
Do Me a Favour "Let's PLay HOli" Rang mE hi PYaar ga GHOli
|
2007
Bewarse
Username: 2007
Post Number: 1444
Registered: 05-2006
Posted From: 129.188.33.222
| | Posted on Thursday, August 24, 2006 - 3:24 pm: | |
>>ippudunna transactional data lo history tables peddagaa levu...kaavalsina reportslo veellaki historicalgaa performance indicators kaavali..so deenni elaa cheyyaali... idhetta D'chukovaali datamartlo...
everymonth indicators calculate chesukuni table lo store sesukovaala...leka every month end ki data anthaa snapshot laaga store chesukuni kaavalsinappudalla paatha data ni query chesukovaala...usualgaa edhi follow avuthaaru
mama, have two set of tables in different schema. one as staging schema and the other for datamart schema..
in staging schema, just extract data as it is from source and do not truncate these tables. and populate the datamart schema from these tables. |
2007
Bewarse
Username: 2007
Post Number: 1443
Registered: 05-2006
Posted From: 129.188.33.222
| | Posted on Thursday, August 24, 2006 - 3:20 pm: | |
>.but in reports you may not want to see data at that level and may like to see rolled up to either week/month/year...
suppose data secondlevel vundi anuko mama tranaction system lo... user may never want to see the detail level data in the report.. he always may want to see at week level, then roll up to month level, then roll up to year level.. so why do you want to store data at detail level in data mart, while populating data you can aggreagate it to the week level and store it.
and when then want to roll up from week to month, reporting tool will do the aggregations from week to month for you .. but agaian you can have the month data pre-calculated too, but it depends on what reporting tool you are using |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 27208
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Thursday, August 24, 2006 - 3:20 pm: | |
reporting tools ninnatidaaka Cognos and SAS rendu undevi...ninnane Cognos mottham outsourcing to india ani bomb padindhi..so G moosukuni mottham SAS lo build sesukovaali...ETL aswellas reporting
A friend to all is a friend to none |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 27207
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Thursday, August 24, 2006 - 3:18 pm: | |
aithe saana work undannamaata...
maama..inko pedda kochen...ippudunna transactional data lo history tables peddagaa levu...kaavalsina reportslo veellaki historicalgaa performance indicators kaavali..so deenni elaa cheyyaali... idhetta D'chukovaali datamartlo...
everymonth indicators calculate chesukuni table lo store sesukovaala...leka every month end ki data anthaa snapshot laaga store chesukuni kaavalsinappudalla paatha data ni query chesukovaala...usualgaa edhi follow avuthaaru
A friend to all is a friend to none |
2007
Bewarse
Username: 2007
Post Number: 1442
Registered: 05-2006
Posted From: 129.188.33.222
| | Posted on Thursday, August 24, 2006 - 3:16 pm: | |
what reporting tool you are using mama... |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 27206
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Thursday, August 24, 2006 - 3:15 pm: | |
but in reports you may not want to see data at that level and may like to see rolled up to either week/month/year...
correste idhi kaavali...
A friend to all is a friend to none |
2007
Bewarse
Username: 2007
Post Number: 1441
Registered: 05-2006
Posted From: 129.188.33.222
| | Posted on Thursday, August 24, 2006 - 3:11 pm: | |
mama, if you know how the users drill up/down, you can have that data pre-calculated and stored in fact tables. |
2007
Bewarse
Username: 2007
Post Number: 1440
Registered: 05-2006
Posted From: 129.188.33.222
| | Posted on Thursday, August 24, 2006 - 3:09 pm: | |
mama
ala aithey nenu kinda cheppinavi anni cheyyali.. since users expect data to be aggregated... so kurchoni baga design cheyyuuu..
first identify the facts/dimensions/level of detail..
level of detail enduku antunna ante.. suppose trnsaction system may store data at second level, but in reports you may not want to see data at that level and may like to see rolled up to either week/month/year...
better thing is have detail data in few tables, and try to have fact tables, with data aggreagted, arranged in as many star schemas as possible based on the reporting requirements |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 27205
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Thursday, August 24, 2006 - 3:08 pm: | |
maama,nee kindhi post lo drill down unte aggregation cheyyaali annaavu datamartlo....kaani drilldowns unte roll up chesukunedhi cube lo kadhaa...so akkada raasukovalemo kadhaa logic... datamart lone aggregate chesthey drill down elaa possible avuthundhi...
A friend to all is a friend to none |
2007
Bewarse
Username: 2007
Post Number: 1439
Registered: 05-2006
Posted From: 129.188.33.222
| | Posted on Thursday, August 24, 2006 - 3:04 pm: | |
if users are expecting same kind of reporting functionality out of datamart as currently provided of source tables, you can just extract the tables as they are and dump them in database.. this is like data migration... |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 27204
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Thursday, August 24, 2006 - 3:03 pm: | |
maama...veellu datamart ki eladaamani decide avvaneeki main reason entante transactional database query chesetappudu chaala joins dobbinchukovaalsi vasthaandhi...reporting tough ayipoindhi...so data ni konchem aggregate chesi datamart laaga pettalanukuntunnaru....
drill through anni dobbinchukuntaayi...so basic gaa aggregating data pedda undadhu...joins ni easy chesthey saripothundemo...andukani oka 10 views raasesi daaniki datamart ani peru pedithe saripothundhi anukuntunnaa...
A friend to all is a friend to none |
2007
Bewarse
Username: 2007
Post Number: 1438
Registered: 05-2006
Posted From: 129.188.33.222
| | Posted on Thursday, August 24, 2006 - 3:01 pm: | |
mama,
mostly it depends on your reporting needs... you can even just extract the tables as they are in source, if your reporting does not expect you to provide drill down/up, aggregation functionality... |
2007
Bewarse
Username: 2007
Post Number: 1437
Registered: 05-2006
Posted From: 129.188.33.222
| | Posted on Thursday, August 24, 2006 - 2:59 pm: | |
ounu mama.. data mart ki kuda.. mari direct ga chesthunnavu gada DWH lekunda.. mari cheyyali |
2007
Bewarse
Username: 2007
Post Number: 1436
Registered: 05-2006
Posted From: 129.188.33.222
| | Posted on Thursday, August 24, 2006 - 2:59 pm: | |
Coming to reports
1. identify what level of detail your reporting expect your data to be in datamart, accordingly aggregate the data along all the dimensions
2. identify the hierachies, if your users expect drill down and roll up functionality in your reports |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 27203
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Thursday, August 24, 2006 - 2:58 pm: | |
idhanthaa DWH design procedure kadhaa....datamart ki kooda ivanni D'chukovaalaa
A friend to all is a friend to none |
2007
Bewarse
Username: 2007
Post Number: 1435
Registered: 05-2006
Posted From: 129.188.33.222
| | Posted on Thursday, August 24, 2006 - 2:56 pm: | |
GOCHI mama, asala aggragtions kavala meeku..
1. what kind of data is it...
2.what kind of reports do you build based on this data later..
3. identify the facts and dimensions
4. identigy the type SCD' you require
5. choose among star/snow-flake/normalized approach to create the tables |
2007
Bewarse
Username: 2007
Post Number: 1434
Registered: 05-2006
Posted From: 129.188.33.222
| | Posted on Thursday, August 24, 2006 - 2:53 pm: | |
GOCHI mama data mart lo kuda malla facts, dimensions vuntayii...
Star schema is denormalized schema
In Snow Flake Schema, the dimensions are normalized and fact tables are de-normalized... |
Gudiwada
Vooriki Bewarse
Username: Gudiwada
Post Number: 2689
Registered: 11-2004
Posted From: 161.225.129.10
| | Posted on Thursday, August 24, 2006 - 2:51 pm: | |
thanxu..ippudu maaku DWH ledhu...directgaa transactional database nundi ETL sesukomantunnaru
Shame to Shame maadhi kuda
 |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 27201
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Thursday, August 24, 2006 - 2:51 pm: | |
MOLAP or ROLAP???
ivanni eppudo interviewlaki sadivinattu gurthu...deeni concept endo kooda seppu detailedgaa appudu septhaa maadento
A friend to all is a friend to none |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 27200
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Thursday, August 24, 2006 - 2:50 pm: | |
 thanxu..ippudu maaku DWH ledhu...directgaa transactional database nundi ETL sesukomantunnaru....
datamart ante normalization laantivi lite lite theesukovacchaa....endukante already unna transactional database normalized one...so daanni malla aggregate sesi normalize seyyalante gosi thadidpothundhi... datamartlo malli fact,dimension tables concept vaadakkaraledhaa..lekapothe malli avi kooda kudusukovaaala...
just oka padhi views raasinattu raasi D'dhaamani plannings...etantaav
A friend to all is a friend to none |
2007
Bewarse
Username: 2007
Post Number: 1433
Registered: 05-2006
Posted From: 129.188.33.222
| | Posted on Thursday, August 24, 2006 - 2:47 pm: | |
mama mimmalni build cheyyamandi datamart MOLAP or ROLAP??? |
2007
Bewarse
Username: 2007
Post Number: 1432
Registered: 05-2006
Posted From: 129.188.33.222
| | Posted on Thursday, August 24, 2006 - 2:46 pm: | |
data warehouse will have all the data at enterprize level..
one more difference is data warehouse usually will have data at detail level, whereas in datamart the data is aggragted along the dimensions... |
2007
Bewarse
Username: 2007
Post Number: 1431
Registered: 05-2006
Posted From: 129.188.33.222
| | Posted on Thursday, August 24, 2006 - 2:45 pm: | |
datamart is subset of datawarehouse... datamart is specific to a division in organization like sales data mart which caters to reporting need of sales department...
In general, data warehouse feeds the data mart.. we can also also build datamart without having to build DWH. we usually follow star or snowflake schema to build datamart.. hammayya kakkesa |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 27199
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Thursday, August 24, 2006 - 2:42 pm: | |
maama...datamart ki datawarehouse ki basic dipperence enti...maa companylo datamart okati build cheyyamantunnaru...so datamart design chesetappudu basic design steps emanna follow avvaala...ante any schema in particular
A friend to all is a friend to none |
Pda
Bewarse
Username: Pda
Post Number: 1128
Registered: 06-2006
Posted From: 129.138.18.85
| | Posted on Thursday, August 24, 2006 - 2:41 pm: | |
mattadukondi nenu pollow avutaa |
Gudiwada
Vooriki Bewarse
Username: Gudiwada
Post Number: 2687
Registered: 11-2004
Posted From: 161.225.129.10
| | Posted on Thursday, August 24, 2006 - 2:40 pm: | |
nenu mataldukonivvanu |
2007
Bewarse
Username: 2007
Post Number: 1429
Registered: 05-2006
Posted From: 129.188.33.222
| | Posted on Thursday, August 24, 2006 - 2:40 pm: | |
enti adugu |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 27198
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Thursday, August 24, 2006 - 2:40 pm: | |
 maama....konchem datawarehousing basics gurinchi maattadukundhaam..preeega unte itu raa
A friend to all is a friend to none |
