MSBI Tutor

The Merge transformation combines two sorted datasets into a single dataset. The rows from each dataset are inserted into the output based on values in their key columns. By including the Merge transformation in a data flow, you can perform the following tasks: ·          Merge data from two data sources, such as tables and files. ·          Create complex datasets by nesting Merge transformations. ·          Remerge rows after correcting errors in the data. The Merge transformation is similar to the Union All transformations. Use the Union All transformation instead of the Merge transformation in the following situations: ·          The transformation inputs are not sorted. ·          The combined output does not need to be sorted. ·      ...

Step 1: Open SQL server management studio and right click on database.         tasks -----> Backup Step 2: In this window give a path where it is saved in your PC Step 3:  Click OK Step 4: Default it is saved in C Drive

This is used to derive new columns by using any of the following. Constants or static values Other columns Variable values Step 1: Click Windows button and go to SQL Server 2008 R2 and run as a administrator. It shows  a bellow window. Step 2: Go to a views and create a new project ( Short cut of New Project is Ctrl + Shift + N). Step 3: Give a project name (e.g. IS) and click OK button and then shows a bellow window. Step 4: To drag and drop the Data Flow Task Step 5:  To edit the Data Flow Task then it open a Data Flow Stem 6: To dag and drop the OLEDB source and edit it Step 7: To give a OLEDB connection and select the table from given data base and select which columns are required. Step 8: Select table as [Sales].[Sales TaxRate]. Step 9: Dag and drop derived column transformation and edit it. Step 10: Add new column as DC and write a bellow expression T...

Step 1: Open SQL server management studio and right click on database and select Restore Database  Step 2: Give a name which database is restore in To Database Step 3: Browse a restore database file where it is located in your PC Step 4: Click on Dialog box and click OK Step 5: Go to SQL server management studio and view a restore database Step 6: Same process follow a bellow steps