Synopsis: Pseudo Key Neat-Freak
Let’s get introduced to the issues that arise because of having gaps in the data.
We'll cover the following...
Imagine the following scenario. Your manager approaches you, holding two report printouts. “The bean counters are saying we have discrepancies between this quarter’s report and the last quarter’s report. I’m looking at them, and they’re absolutely right. Most of the later assets have disappeared. What happened?”
You look at the reports, and the pattern of discrepancies rings a bell. “No, everything is still there. You asked me to clean up the rows in the database, so there are no missing rows. You said the accountants kept asking you questions about missing assets because of ...