When to Use
- The destination does not accept nulls (e.g. NOT NULL constraint).
- You want a fallback for missing values (e.g. ‘Unknown’ for null country).
- Analytics require a default (e.g. 0 for null numeric columns).
Example
Fill nulls incountry with 'Unknown':
| Before | After |
|---|---|
| USA | USA |
| null | Unknown |
| UK | UK |