handling cases in fact table
Page 1 of 1 • Share •
handling cases in fact table
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!
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
Re: handling cases in fact table
Usually the issue is late arriving dimensions. What is the issue with late arriving facts?
ngalemmo- Posts : 3000
Join date : 2009-05-15
Location : Los Angeles
Re: handling cases in fact table
Yes, indeed the case is late arriving dimensions.
How this case can be solved with an SCD type 2 dim ?
How this case can be solved with an SCD type 2 dim ?
NewDpr- Posts : 4
Join date : 2014-11-15
Re: handling cases in fact table
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

» How to move my selenium test cases from Rc to Grid
» Urgent --- how to get links under specific panel/ div/ table
» table -div
» Executing Same test cases in multiple browsers simultaneously
» How to get total rowcount of a table using Selenium IDE
» Urgent --- how to get links under specific panel/ div/ table
» table -div
» Executing Same test cases in multiple browsers simultaneously
» How to get total rowcount of a table using Selenium IDE
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum