InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
Explain How To Handle Early Arriving Facts Or Late Arriving Dimension? |
|
Answer» LATE Arriving Dimension are unavoidable, to HANDLE these we can create a dummy dimensions with natural/business key and keep the rest of the attributes as null or default. So when actual dimension arrives, the dummy dimension is updated with Type 1 change. This is also referred as INFERRED Dimensions. Late Arriving Dimension are unavoidable, to handle these we can create a dummy dimensions with natural/business key and keep the rest of the attributes as null or default. So when actual dimension arrives, the dummy dimension is updated with Type 1 change. This is also referred as Inferred Dimensions. |
|