Base table and view in Microsoft SQL Server

View: 1.Views are created from one or more than one tables. 2.Acting as a layer between user and table 3.Reducing the effort while writing queries to access multiple specific columns from many tables 4. Allowing us to hide some columns from the user because of security reasons. 5.View doesn't contain any data. 6. We can … Continue reading Base table and view in Microsoft SQL Server

Advertisements

Synchronous & Asynchronous components in SSIS

In SSIS data flow, there are three types of data transformation:  non-blocking, semi-blocking and fully-blocking and all data flow components are categorized to be synchronous vs asynchronous. We need to understand their properties and how to organize them appropriately. Synchronous components: simply, number of records IN = number of records OUT in buffer cache. Asynchronous … Continue reading Synchronous & Asynchronous components in SSIS

The differences between Kimball and Inmon approach in designing data-warehouse

If you are working in data warehousing project or going to work on data warehouse project, the two most commonly designed methods are introduced by Ralph Kimball and Bill Inmon. Which advantages  / disadvantages of these approaches? Which one is better/ suitable for your business requirement? Lets understand the basic difference between Ralph Kimball and … Continue reading The differences between Kimball and Inmon approach in designing data-warehouse