Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Sohum
Starting Member
1 Post |
 Posted - 2008-06-22 : 02:32:08
|
| Hi friends,Can somebody tell me how to do this- How can we Analyze existing code used to transform data into the Operations Data Warehouse, and make changes to correspond to upcoming changes in the SAP data sources.Thankssk |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-22 : 03:21:28
|
| Do you mean checking for the changes in your source database and then reflecting them onto your data warehouse like inserting newly added information,updating modified ones and deleting those which were removed from source?If this is what you want, you can write an SSIS package which does this for you. it will consist of a source connection to SAP db,then some transform tasks if you need to apply any changes to source data, a SCD task which will check for the data changes and perform insert,update or delete and will reflect them onto destination using a destination connection. Please let us know if you need more info on this. |
 |
|
|
|
|
|
Data Transform