Rather than treating freeform comments as textual metrics in a fact table, they should be stored outside the fact table in a separate comments dimension with a corresponding foreign key in the fact table.
If the comments’ cardinality matches the number of unique transactions, they can also be stored as attributes in a dimension with one row per transaction (like a degenerate dimension table).
Fact Table
transaction_id
date_key
customer_key
comment_key
amount
TXN-123
20260101
C-100
COM-5
$100
Comments Dimension
comment_key
comment_text
COM-5
Customer requested expedited shipping due to holiday.
Text Comments Dimension
Rather than treating freeform comments as textual metrics in a fact table, they should be stored outside the fact table in a separate comments dimension with a corresponding foreign key in the fact table.
If the comments’ cardinality matches the number of unique transactions, they can also be stored as attributes in a dimension with one row per transaction (like a degenerate dimension table).
Fact Table
Comments Dimension