handling cases in fact table

View previous topic View next topic Go down

handling cases in fact table

Post  NewDpr on 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

View user profile

Back to top Go down

Re: handling cases in fact table

Post  ngalemmo on Wed Jun 17, 2015 11:32 am

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

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

View user profile http://aginity.com

Back to top Go down

Re: handling cases in fact table

Post  NewDpr on 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

View user profile

Back to top Go down

Re: handling cases in fact table

Post  ron.dunn on 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

View user profile http://ajilius.com

Back to top Go down

Re: handling cases in fact table

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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