November 14, 2007 at 1:34 am
Can anyone help regarding the SQL server integration Services(SSIS), ETL
We have requirement like this:
We have Live Database( LIVE_DB ) and Reports Database (REP_DB)
I want to trasfer the few tables data from LIVE_DB into the REP_DB for end of the day using SSIS
If any new records are added, updated or deleted in LIVE_DB, these should reflect in the REP_DB, Our requirement is not to delete the old data, we should append or delete or insert the new transaction data in REP_DB.
Thanks in advance, if anyone help me in resolving this issue.
Regards,
Bhushanam.
November 14, 2007 at 5:46 am
Assuming you have a primary key (or some unique key that cannot be changed on a record) you can do this very easily.
Look at the SCD wizard.
Yes, it is true that you are not updating a dimension, but the wizard will walk you through exactly what you are proposing.
November 20, 2007 at 10:41 am
Michael Earl (11/14/2007)
Assuming you have a primary key (or some unique key that cannot be changed on a record) you can do this very easily.Look at the SCD wizard.
Yes, it is true that you are not updating a dimension, but the wizard will walk you through exactly what you are proposing.
Hi i got 60 sql servers i would like to find version of sql server and service
from one server to all servers how can i do that ?
October 12, 2012 at 3:44 pm
You must first define the way you will capture the changes in the LIVE_DB.
What is the retention policy of this,
you can partition your data by datetime and have a full load to the rep_db
or can have logical deletion in REP_DB
Again, the question is what means you will use to detect the changes?
If you want to go with logical deletion use SCD techniques , also you need the changes capyture abiity.
It can be done through audit, triggers , row version etc..
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply