Best Practice to handle NULL value in fact table

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Good morning!

What is considered best practice to handle NULL values in a fact
table. My fact table has a field for PO Number, but not everyrecord
had one.

Should I put a dummy number in those records and add the dummy value
to the dimension?

Or should I leave it NULL and have the Error Configuration handle it?

Thanks,
Kathryn
.

Relevant Pages

  • Re: Retrieving unnecessary data
    ... Robert Martin wrote: ... they are taught should be consumed more, but in practice mostly ... The other 10% know the OO fanboys are exaggerating ... One can also write a dummy stub function f, ...
    (comp.object)
  • Re: Is "Thank you, partner" ethical?
    ... David Stevenson wrote: ... wonderful" it just implies partner has put the dummy down. ... In practice, well, no so much. ...
    (rec.games.bridge)
  • Re: Grappling, striking or sticks first?
    ... (you have to drink twice: judo needs two to practice. ... dummy is a teetotaler) ...
    (rec.martial-arts)
  • Re: Mis-concession of high trump to opponents
    ... derek wrote: ... to think that I'd call the director in this case, too, but in practice ... I know I tend to not pay enough attention when I'm dummy to even know ...
    (rec.games.bridge)
  • Re: recycling internationalized garbage
    ... def checkEncoding: ... (uni, dummy) ... In practice it's more complicated than that. ...
    (comp.lang.python)