.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Slowly Changing Dimension, how does it work ?

Posted By:      Posted Date: September 13, 2010    Points: 0   Category :Sql Server
small dimension DimBranch, there are only 3 columns - coutry,city,branch - three together is unique key every time when package runs - just  truncate table DimBranch - insert  distinct coutry,city,branch into DimBranch from ... easy and works nice, I always sure that all rows are came (new one, changed one and etc) but would like to try use all benefits from SSIS like Slowly Changing Dimension so, how to setup SCD in my case ? what is a business key ? I don't need to keep historical data, only update existing or insert new one

View Complete Post

More Related Resource Links

In SSIS 2005 how can I implement Slowly Changing Dimension Type 6

Hi I can't see SCD Type 6 in SSIS 2005 ,how do I get add  into my data flow task and if anybody can explain me step by step process for SCD type 6

Slowly Changing Dimension in SSIS

Hi I am new to SSIS and i have read concepts of Slowly changing dimensions ( Type 1,2 and 3). Can any one suggest some examples or tutorils to implement this in a SSIS package for better understanding how does it works in SSIS?   MAny Thanks Ravi.S

Need step by step help for Slowly Chaging Dimension In SSIS 2005

Hi I have never used Slowly Changing Dimension ,my manager told me that i  have to use use type 2 for this i am not sure what is business key and all,please help me step by step process I have a source table like this [dbo].[CapabilitySpecialty](  [SpecialtyCd] [varchar](30) NOT NULL,  [SpecialtyDesc] [varchar](256) NULL,  [CapabilityCd] [varchar](30) NULL,  [CapabilityDesc] [varchar](256) NULL,  [WorkgroupCd] [varchar](15) NULL,  [WorkgroupDesc] [varchar](100) NULL,  [WorkforceGPSCapabilityCd] [varchar](15) NULL,  [WorkforceDesc] [varchar](100) NULL Now  I have destination table looks like this [Price].[DimCapabilitySpecialty](  [CapabilitySpecialtyKey] [int] IDENTITY(1,1) NOT NULL,  [SpecialtyCd] [varchar](30) NOT NULL,  [SpecialtyDesc] [varchar](256) NULL,  [CapabilityCd] [varchar](30) NULL,  [CapabilityDesc] [varchar](256) NULL,  [WorkgroupCd] [varchar](15) NULL,  [WorkgroupDesc] [varchar](100) NULL,  [WorkforceGPSCapabilityCd] [varchar](15) NULL,  [WorkforceDesc] [varchar](100) NULL  

Can't Get Changing ContextMenu to Work With ToolboxControl


Hi, I've got a project in which I'm trying to create a ToolboxContol that has a ContextMenu associated with it. Depending on the type of activity that is right-clicked, I want the menu to show different options. I figured that the easiest way to do this is to attach a handler to the ToolboxControl's PreviewMouseRightButtonDown event, in which I repopulate the menu with the appropriate options before it is shown.

There's one problem though. I can't find any way to determine which activity has been right-clicked. The ToolboxControl's SelectedItem activity tells you which one is selected, but right-clicking doesn't select an activity, and I can't find any way to identify the activity that is currently highlighted by mouse-over. Is there any way to do what I want here?

Issue while programmatically Slowly Chaging Dimension.



I am working on Creating an SSIS package to add Slowly Chaging Dimension to the package programmatically.

I have done the following steps:

1.           Choosing the connection manager to access the data source that contains the dimension table that you want to update.

  You can select from a list of connection managers that the package includes.


Changing the graphics on the home page of a SharePoint site

When you create a site in Microsoft Windows SharePoint Services by using the default Team Site template, the home page includes two default graphics. A Windows SharePoint Services graphic appears in the body of the page, and a picture of a house in a circle appears near the site title. You can change these graphics to customize your site. Changing the smaller graphic requires a Windows SharePoint Services compatible Web page editor

RadioButton inside GridView, How to get it work as normal

Did you tried before to drag a RadioButton control inside a Gridivew templatefield, and then you attempt to select these RadioButtons , you will notice that the behavior of RadioButton control will be changed and it will work just like the behavior of checkbox control! the user will be able to select more than one radiobutton in the grid!

Convert English to Arabic number without changing any regional settings in .net

Well, most applications that I worked with was multilingual that supports English UI and Arabic UI.

And one of the major issue that we have faced is displaying Arabic numbers without the need of changing the regional settings of the PC.

So the code below will help you to display Arabic number without changing any regional settings.

Looking for guidance: wanting to work with AJAX architecture



I'm starting a small website that will be backed by a database, and will allow a small number of users to authenticate and select an entry in the database, and then view (and optionally update) a corresponding entry (think master-detail).

I have some flexibility in how I'll do this, but I'd really like to incorperate some newer AJAX style coding, eliminating some page postbacks. I think this is a great opportunity to learn the concepts well.

I'll probably go with an ASP.NET 4.0 site. From what I've seen there are MANY ways to go about this:

-WCF Data Services to expose the data, and consume in ASP.NET

-Page methods to expose the data, separate method to update the data

-I'd rather avoid the UpdatePanel because I'm really looking for a full hands-on approach, with learning client side scripting being an objective as well.

Beyond that, it seems that one can use jQuery to build clientside templates, but also one can use the ASP.NET AJAX template engine (in ASP.NET 4.0 I believe).

A concern I have: users should only be able to work with the data exposed via these endpoints if they are logged into the website. Hopefully I can somehow reuse the ASP.NET forms authentication cookie for this purpose. 

Well, I hope I've posted enough to a

animate effect work but the render items are messed up.


Hi all,

     I have a very unique problem, humm i think. I am using a jquery effect that animate bounce effect, i have a line in my javascript pageLoad function $("#UserBrowserInfoDIV").show('bounce'); - the effects run smoothly but what it does is mess up the bolded text in the div. I have try the items inside the div without bolding and it works fine and no render problem but when bolded the text that are bolded is quite messed up, and barely readable.

Please let me know is there anything else i can do i really would like use this effect.

P.S all the effect have the same render problem, and i am using ie8 under compatibility mode.





Why getTreeNode does not work?



I try to run a  treeview example from msdn:


I also want to use code from


Here is my code:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<%@ Register TagPrefix="mytree"
Assembly="Microsoft.Web.UI.WebControls" %>
 <script type="text/javascript" language="javascript">

     function xxx() {

         var myNode = treeview_one.getTreeNode(treeview_one.selectedNodeIndex);


<form id="myform" runat="server">
<mytree:treeview id="treeview_one"  runat="server" Child

Category attribute of user control property does not work correctly in categories tab.



I have a User Control (ascx) and a property which a want to display in my categories tab in Visual Studio in the category named "Styles".

[Category("Styles"), DefaultValue(""), Description("The value for formating something.")]
public String MyFormatProperty
set { /* the code for set */; }
get { /* the code for get */; }

And here is the problem: Actually I do not need a get, because I only have to set the property (write only property). But when I omit the get, the property is displayed in the "Misc" category in the categories tab in Visual Studio. Only when I code the get as well, then the property is displayed correctly in the "Styles" category in the categories tab in Visual Studio.

Does anybody know why? How can I display the category correctly only with set?

Thanks, S.

Problem with changing language using culture info


I'm using the following msdn article to use different languages in my web application:


I'm following the instructions step by step in VS 2010, and it creates the resource files exactly how it's supposed to. 

However, when I run the program it just doesn't apply it. I don't see the different values from the resource file. 

If I leave my resource file name as sample.aspx.resx, it works. But when I change it to sample.aspx.en-us.resx, it doesn't work. I'm supplying culture from the aspx page's Culter and UICulture properties. I'm being very careful in choosing the correct file name, as that could be the issue,  but it just doesn't work. I also tried changing the culture in the backend code this way:

Changing direction of pop-ups/alerts in RTL


Hello All,

I am not able to change the direction of popups/Alerts in Arabic culture which should be RTL direction.

Rest of my application is changed in above culture, only problem is with popups and alerts.

Thanks in advance.

Changing from Local to WCF


I've been handed an application thats connection string implies a local host connection.

I want to make this connection a remote connection, to a database located on a Server.  I want the client and server to be able to communicate with one another remotely, instead of a local connection.

How does one create the Data Service, and establish end points to Server and Client?  Is it as simple as creating a contract (which I have limited knowledge on constructing), between the two locations, setting up the dataservice, security, and ratifying the 'connetions'?

A smidge of insight, please ;-)

Changing classic asp.net Menu to CssAdapterMenu


Hello Friends,

                     I have been using asp.net menu control that is programmatically binded at runtime and has n child node levels. Now i want to use CssAdapterMenu instead because the menu control contains more than 1000 menuItems(in the near future it can also be more 2000 menuItems) and has very slow response in IE 6 or IE 7.

                    Now my question is how should i change the classic asp.net menu to CssAdapterMenu. What should be the steps? Any samples example of n child node levels would be helpful


Team System: Customizing Work Items


Team Foundation Server's work iIem tracking system provides a number of advanced customization options.This article explores custom control support that lets you link to date, enhance the user experience, present data, and more.

Brian A. Randell

MSDN Magazine October 2009

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend