How do you handle late-arriving facts?
For example, a claim payout happened last Tuesday, but it only entered the system today.
Answer:When the late record arrives during our ETL run, our pipeline reads the transaction date, places it into the correct historical partition
----------------------------------------------------------------
Q5: did you use one "Factless Fact Table, in your insurance project?
Answer:
A factless fact table is a table that contains no numeric metrics or measurements; it only tracks events, relationships, or coverage conditions.
Yes, we used one in our insurance project.
We created a Fact_Policy_Coverage table to track which policies had specific optional coverages (like roadside assistance or flood insurance) attached to them. It had no monetary value inside it, but it allowed the business to run reports on how many customers opted for specific packages.
No comments:
Post a Comment