Unique, redefined

Click here to visit Original posting

Engineering group at this manufacturing company comes up with a new quality-control initiative: Assign a unique identifier to each part, according to a database analyst pilot fish working there.

"Each part's serial number and identifier were to be sent via secure FTP to a site, and they wanted me to come up with a database table and a job to import the data," fish says.

"During the kickoff meeting, I asked if they wanted me to check for duplicates to insure their data was pure -- and was told, 'Duplicates won't happen.'"

Fish has worked in manufacturing IT for decades, and he knows there's always a chance for data to be duplicated. So he asks again, "But what if--?"

To read this article in full, please click here