I have a transaction table that contains a large number of rows (more than 40 millions) ,
I want to design SSIS package to transfer data from the transaction table into the data warehouse, which would be an incremental load.
which mean , IF transaction.ID not exists in the destination table --> then --> Insert new row
My question is : what is the best approach for the incremental load? while I need to transfer data every 15 minutes.