InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
How To Handle Late Arriving Dimension Or Early Arriving Facts.? |
|
Answer» Late arriving dimensions sometime get unavoidable 'coz delay or error in Dimension ETL or may be due to LOGIC of ETL. To handle Late Arriving facts, we can CREATE dummy Dimension with natural/business key and KEEP rest of the attributes as null or default. And as SOON as Actual dimension ARRIVES, the dummy dimension is updated with Type 1 change. These are also known as Inferred Dimensions. Late arriving dimensions sometime get unavoidable 'coz delay or error in Dimension ETL or may be due to logic of ETL. To handle Late Arriving facts, we can create dummy Dimension with natural/business key and keep rest of the attributes as null or default. And as soon as Actual dimension arrives, the dummy dimension is updated with Type 1 change. These are also known as Inferred Dimensions. |
|