I have several databases for the same program which I am working to use an ETL program to move data over into a brand new database.
Several of the entities, Items, Projects, Employees, have duplicate IDs or Keys and we are going to have to Recode, change, update etc so those so there are no duplicates in the final database. Many to One.
My questoin is simply, what is this process called? A co-worker is calling this normalization, but as I read about that term, that doesn't seem like the right term. Does anyone know what this procedure is called??
Thanks so much!