Krishan Kayat

Most ETL tools provide some functionality for handling slowly changing dimensions. Every so often, when the tool isn’t performing as needed, the ETL developer will use the database to identify new and changed rows, and apply the appropriate inserts and updates. I’ve shown examples of this code in the Data Warehouse Lifecycle in Depth class using standard INSERT and UPDATE statements. A few months ago, my friend Stuart Ozer suggested the new MERGE command in SQL Server 2008 might be more efficient, both from a code and an execution perspective. His reference to a blog by Chad Boyd on MSSQLTips.com gave me some pointers on how it works. MERGE is a combination INSERT, UPDATE and DELETE that provides significant control over what happens in each clause. This example handles a simple customer dimension with two attributes: first name and last name. We are going to treat first name as a Type 1 and last name as a Type 2. Remember, Type 1 is where we handle a change in a dimension attribute

When you try to connect to the Internet, the connection might fail when we run the Troubleshooter and you might get this error:   The device or resource (DNS server) is not responding. DNS Server is not responding In such a scenario, there are few things you could try to resolve it. 1.       First backup your Router settings and update the Firmware of your Router. Check the Router manual for more information 2.       Next thing is to change the DNS server address manually. Go to Start and Click on Control Panel Open up Network and Internet and go to the Network and Sharing Center. Click on Change adapter settings Now you’ll see the list of Network adapters select the Network adapter  that your using and right click on it and go to properties Then Click on “Internet Protocol Version 4 (TCP/IPv4)” You’ll see the Internet Protocol Properties Select “Use the Following DNS server address:” Enter the Preferred DNS address:   208.67.222.22

SELECT DISTINCT o.[name] AS [Table] FROM [sysobjects] o JOIN [sysobjects] tr ON o.[id] = tr.[parent_obj] WHERE tr.[type] = 'tr' ORDER BY [Table] If you want to know all name of the triggers then run the query select * from sys.triggers hope it'll helpfull