Results 1 for
"Late Arriving Facts"
Preserving prior history for late arriving dimensions
Can't find much about this topic anywhere else so hopefully someone can help me. Our warehouse has late arriving dimensions for an Employee. Their department changes, for example, can be backdated in the systems and so we have to account for this and
Can't find much about this topic anywhere else so hopefully someone can help me. Our warehouse has late arriving dimensions for an Employee. Their department changes, for example, can be backdated in the systems and so we have to account for this and
Large number of late arriving facts
I am loading a Star Schema from a data base that acts as the staging area. We are converting our source systems to a new transaction system. We are converting data to the new transaction systems in large chunks with conversion dates spread over 3 years.
I am loading a Star Schema from a data base that acts as the staging area. We are converting our source systems to a new transaction system. We are converting data to the new transaction systems in large chunks with conversion dates spread over 3 years.
Business keys in Fact. Is this accepted?
It is a data warehouse optimization project and a very basic data warehouse is in place. There are a couple of dimensions with only 2, 3 columns only (<30 rows) and where the Business key can be easily interpreted. Ex: Event_Type_DIM: this has 2
It is a data warehouse optimization project and a very basic data warehouse is in place. There are a couple of dimensions with only 2, 3 columns only (<30 rows) and where the Business key can be easily interpreted. Ex: Event_Type_DIM: this has 2
Updating a Fact Table
I currently working on an Accounting Datamart which the dims and facts are loaded daily. I have recently had a request to update the data after its been loaded. The best way for me to explain this is to give an example. The data is loaded daily, so
I currently working on an Accounting Datamart which the dims and facts are loaded daily. I have recently had a request to update the data after its been loaded. The best way for me to explain this is to give an example. The data is loaded daily, so
Multiple facts in a fact table
One proposed model for our business (wholesale/retail) sales fact is to have every register ring in one fact. This causes refunds, voids, coupons and other 'facts' to be stored in a single fact entity. There is a column type dimension that then tells us
One proposed model for our business (wholesale/retail) sales fact is to have every register ring in one fact. This causes refunds, voids, coupons and other 'facts' to be stored in a single fact entity. There is a column type dimension that then tells us
Handling late changes to Type 2 attributes
Hi. I'm trying to find a good way to handle late changes to Type 2 attributes. Please note that I am not asking about early-arriving facts that could be handled with an inferred dimension member. Rather, I am interested in the situation where the dimensio
Hi. I'm trying to find a good way to handle late changes to Type 2 attributes. Please note that I am not asking about early-arriving facts that could be handled with an inferred dimension member. Rather, I am interested in the situation where the dimensio
Textual Facts in the fact table
Its a new financial 'capital markets' dimensional reporting model (for IPO - raise money for an issuer by issuing new equity common stock securities) that's in design stage. There are some textual attributes of the grain of several fact tables for which
Its a new financial 'capital markets' dimensional reporting model (for IPO - raise money for an issuer by issuing new equity common stock securities) that's in design stage. There are some textual attributes of the grain of several fact tables for which
[MV] Too Late - Co-Ed School (720p)
Cre NamNyeoGongHak Re-up by panda@paruce.com, panda_tiafan@t-araworld.com
Cre NamNyeoGongHak Re-up by panda@paruce.com, panda_tiafan@t-araworld.com
Late at night when all the world is sleeping
Late at night when all the world is sleeping. I stay up and think of you. And i wish on a star that somewhere you are thinking of me too. Cause i'm dreaming of you tonight. Till tomorrow, I'll be holding you tight. And there's nowhere in the
Late at night when all the world is sleeping. I stay up and think of you. And i wish on a star that somewhere you are thinking of me too. Cause i'm dreaming of you tonight. Till tomorrow, I'll be holding you tight. And there's nowhere in the
Facts with different grain from different sources but related
Hi, I have a situation which I am trying to resolve but not able to Technologies Using : SQL Server and Analytics Services (SSAS) Background I have a flat file which is from the enterprise peoplesoft system and has the followings GL Account,
Hi, I have a situation which I am trying to resolve but not able to Technologies Using : SQL Server and Analytics Services (SSAS) Background I have a flat file which is from the enterprise peoplesoft system and has the followings GL Account,
Multiple one to many facts
Trying to figure out how to model this with multiple one to many facts. I'm new to modeling so bear with me if this is simple. I think a picture speaks a thousand words so here is this: There's a few dimensions as well but those are easy
Trying to figure out how to model this with multiple one to many facts. I'm new to modeling so bear with me if this is simple. I think a picture speaks a thousand words so here is this: There's a few dimensions as well but those are easy
Facts or Dimension Attributes?
My company is currently building a data warehouse and I have a design issue that I am not sure how to address. In general, our business is selling an asset, such as the stock of a corporation, with a certain number of shares and a value. The value of th
My company is currently building a data warehouse and I have a design issue that I am not sure how to address. In general, our business is selling an asset, such as the stock of a corporation, with a certain number of shares and a value. The value of th
Conformance of Dimension for facts aggregated at different levels
I am a newbie to Data Modeling. I am modeling a warehouse for Global reporting solution for a business operating in 3 countries. 2 business processes involved are "Sales" and "shipment Expenses" The input is sumarized excel files
I am a newbie to Data Modeling. I am modeling a warehouse for Global reporting solution for a business operating in 3 countries. 2 business processes involved are "Sales" and "shipment Expenses" The input is sumarized excel files
your interesting facts
so basically you put interesting facts about yourself such as something really good or really bad you have done,something really good or really bad that has happened to you, or just something you want to share about yourself.you can also put any
so basically you put interesting facts about yourself such as something really good or really bad you have done,something really good or really bad that has happened to you, or just something you want to share about yourself.you can also put any
Non-numeric Facts
My customers are challenging me..... They tell me that my reporting models are not flexible enough. I agree, but I am not sure how to approach this issue and give them what they need in a simple way. My products today offers 2 types of reporting today:
My customers are challenging me..... They tell me that my reporting models are not flexible enough. I agree, but I am not sure how to approach this issue and give them what they need in a simple way. My products today offers 2 types of reporting today:
Results 1 to 15 on 87
for "Late Arriving Facts"
for "Late Arriving Facts"
Active topics
Popular topics
Unanswered topics
