| Author |
Message |
    
Blazewada
Celebrity Bewarse
Username: Blazewada
Post Number: 7683
Registered: 08-2008
Posted From: 115.42.133.50
Rating: N/A
Votes: 0 (Vote!) | | Posted on Wednesday, February 24, 2010 - 1:22 am: |
|
Vignana Pradarsana... 
Real Bewarse 
|
Codes
Bewarse Legend
Username: Codes
Post Number: 53328
Registered: 05-2006
Posted From: 80.72.152.155
Rating: N/A
Votes: 0 (Vote!) | | Posted on Wednesday, February 24, 2010 - 1:03 am: |
|
aa rendu kee teda emiti ?
naku ee DWH termnology idea ledu , dimension , fact nee guess kotta.. 
dhobi ka kuttha, na ghar ka na ghat ka
|
420
Celebrity Bewarse
Username: 420
Post Number: 9011
Registered: 12-2006
Posted From: 217.166.42.161
Rating: N/A
Votes: 0 (Vote!) | | Posted on Wednesday, February 24, 2010 - 12:56 am: |
|
Codes:
 ..
OLAP in question here .. not the OLTP models
Knit India,do not split India !
|
Codes
Bewarse Legend
Username: Codes
Post Number: 53327
Registered: 05-2006
Posted From: 80.72.152.155
Rating: N/A
Votes: 0 (Vote!) | | Posted on Wednesday, February 24, 2010 - 12:51 am: |
|
Product.produtID -> ProductToUnitPrice.UnitpriceID -> unitprice.UnitpriceID -> Unitprice.FromDate , Unitprice.ToDate
dhobi ka kuttha, na ghar ka na ghat ka
|
420
Celebrity Bewarse
Username: 420
Post Number: 9010
Registered: 12-2006
Posted From: 217.166.42.161
Rating: N/A
Votes: 0 (Vote!) | | Posted on Wednesday, February 24, 2010 - 12:41 am: |
|
Gwochi
Bemmi ..
DBA baa etc ..
leme put ur DWH datamodeling skills to test ..
what if
1) I have a type2 Dimension
2) Introduce a validity date (begin and end) on the fact? Or still keep this at the dimensions?
One of the needs is that the customer needs to time travel (history needs to be of type 2)
What is the best way to do this? The dimensions can be made in type 2, but what to do with the fact?
I have already Modelled it .. just want to know how u would do it ..
Knit India,do not split India !
|
Archives - 2010