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 |
|
vijay_here
Starting Member
1 Post |
 Posted - 2011-01-31 : 13:35:04
|
| Hello SQL Champs..!Help me in approaching in a right way.. I have a requirement where Monthly Data Export as Delta feed needs to be set up. Monthly report should be delta feed. New data along with Change is previous data to be loaded. For eg, 10 new orders plus, any line item data addition for old orders need to be dealt with, in every delta feed.I guess its SCD of type 2.Can anybody suggest the best way in SQL server 2005.For ex.Dec 2010:Order1, L1, L2Order2, L1,L2,L3etc etcJan 2011Order 2, L1,L2,L3,L4 (Here this Order 2 was in Old feed but, mentioned here also as L4 was newly added line under that)Order 23,L1,L2Order 25, L1,L2etc etc |
|
|
|
|
|
|
|
SCD Delta Feed