Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

handling cases in fact table

3 posters

Go down

handling cases in fact table Empty handling cases in fact table

Post  NewDpr Wed Jun 17, 2015 9:42 am

Hello All,

I would like to know the best way and if possible automatic formula to handle the case : late arriving facts ?
Notice that I am not using an etl tool, only via stored procedure in pl/sql.

Thanks a lot for your help!

NewDpr

Posts : 4
Join date : 2014-11-15

Back to top Go down

handling cases in fact table Empty Re: handling cases in fact table

Post  ngalemmo Wed Jun 17, 2015 11:32 am

Usually the issue is late arriving dimensions. What is the issue with late arriving facts?
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

handling cases in fact table Empty Re: handling cases in fact table

Post  NewDpr Fri Jun 19, 2015 2:46 am

Yes, indeed the case is late arriving dimensions.
How this case can be solved with an SCD type 2 dim ?

NewDpr

Posts : 4
Join date : 2014-11-15

Back to top Go down

handling cases in fact table Empty Re: handling cases in fact table

Post  ron.dunn Sat Jun 20, 2015 7:04 pm

Before you update your fact table, identify those business keys for which dimension rows do not yet exist, and create new dimension rows with each business key. When the dimension update arrives you can update the dimension table. Given that you've mentioned SCD2, you might want to think about special logic for the first update of a row that was created in this manner.

ron.dunn

Posts : 55
Join date : 2015-01-06
Location : Australia

http://ajilius.com

Back to top Go down

handling cases in fact table Empty Re: handling cases in fact table

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum