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 |
|
jim_jim
Constraint Violating Yak Guru
306 Posts |
 Posted - 2010-11-22 : 11:09:24
|
| HiI want to implment slowly changing dimension transformation on my monthly load which I do using multiple flat files.ScenarioI will be loading data into a SQL server table from a flat file.The new Flat file every month consists of some new rows and few modified rows.I know the modified rows will save the history.How will the new rows be treated in the slowly changed dimension ?I really need help on this to keep track of history. |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-11-22 : 11:18:07
|
| Do you mean what is a slowly changing dimension (which type - I would guess type 2) or how do you code it?I would do it using a merge statement - actualy I would use a merge for the inserts and updates and a separate insert for the new rows generated by the updates.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
jim_jim
Constraint Violating Yak Guru
306 Posts |
Posted - 2010-11-22 : 12:20:08
|
| My question is about the Slow Change Dimension Transformation that is directly available for me in the data flow task(BIDS 2008)I tried using the SCD transformation using OLEDB and was able to save history of the records which has updates.I want to use flat file source to load data to a oledb destination and save history.Iam not sure whether I can use the flat file source with Slow Change Dimension Transformation Hopefully Iam making sense |
|
|
|
|
|
|
Slowly changing Dimension