<div>
a lot of people is saying that Slowly changing dimension is very bad and very slow with large data?
</div>


a lot of people is saying that Slowly changing dimension is very bad and very slow with large data?

<div>
what are other options to use instead of &quot;Slowly changing dimension&quot;
</div>


what are other options to use instead of "Slowly changing dimension"

<div>
<div class="content wysiwyg-content">
Dear all<br />
I am starting to create my first SSIS solution<br />
I heard that “Slowly changing dimension” will do the job for me how?<br />
<br />
I want to detect all the new rows added or deleted or edited in specific table, so as far as I understood that “Slowly changing dimension” will do this job for me.<br />
<br />
My question:<br />
Is there any details explanation about how it works?<br />
I need many samples preferred to be video<br />
<br />
Thanks is advance<br />
<br />
<br />
<br />

</div>
</div>


Dear all
I am starting to create my first SSIS solution
I heard that “Slowly changing dimension” will do the job for me how?

I want to detect all the new rows added or deleted or edited in specific table, so as far as I understood that “Slowly changing dimension” will do this job for me.

My question:
Is there any details explanation about how it works?
I need many samples preferred to be video

Thanks is advance





SSIS and “Slowly changing dimension”

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).