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 |
|
Omprakash
Starting Member
4 Posts |
 Posted - 2014-04-13 : 09:53:13
|
| Hi,I am trying to create a type 2 Slowly changing dimension using SSIS. Basically, tracking the changes to a dimension in a table. And I am in an impression that I can only schedule this job to run on a timely basis (Being a novice). Is there any way to make this real time, i.e. if there is any change in the live table, it immediately updates the staging table???Any help would be great.Thanks,Omprakash |
|
|
|
|
|
SCD in SSIS