Currently browsing

August 2017

Handling Foreign Keys – ETL

Issue: About to delete 1Billion record from the table. Goal is to improve ETL process time. Foreign keys are good way to maintain data integrity , there are occasions like this one where you want to disable foreign keys in-order to avoid data integrity check and improve overall performance. Solution: …