Duplicates
2 posters
Page 1 of 1
Duplicates
In the Load of the ETL, I know there may be duplicates that may go against the constraint. Do you normally have to do something to make sure those don't even get inserted? To me, it seems when that error happens, I want it to not insert under those circumstances but I also want it to just continue. Any thoughts? (Maybe this is something that ETL software handles)
braken- Posts : 2
Join date : 2012-11-27
Re: Duplicates
I wouldn't have any constraints on my tables in the first place as this will significantly impact the ETL processing times.
The ETL job should ensure referential integrity through the generation of surrogate keys and resolve issues such as duplicates.
The ETL job should ensure referential integrity through the generation of surrogate keys and resolve issues such as duplicates.
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|