By continuing your visit to this site, you accept the use of cookies. They ensure the proper functioning of our services and display relevant ads. Learn more about cookies and act

Not yet registered? Create a OverBlog!

Create my blog

Shivprasad koirala

Shivprasad koirala

Interview questions for .NET,VB.NET,SQL Server,C#,Design pattern,Sharepoint,WCF,WPF,WWF,Silver light,reporting services,java,tester,software testing

Blogs

questpond.over-blog.com's name

questpond.over-blog.com's name

Interview questions for .NET,VB.NET,SQL Server,C#,Design pattern,Sharepoint,WCF,WPF,WWF,Silver light,reporting services,java,tester,software testing
Shivprasad koirala Shivprasad koirala
Articles : 462
Since : 26/10/2010
Category : Tech & Science

Articles to discover

Short-key error in SSIS project.

Short-key error in SSIS project.

While working with Merge component in SSIS project below is the error got while configuring the component. Here the error is Short key position of the both the input are not organised properly as Shown in below screen shot. Solution Merge component expect that input which come to the merge component should be shorted. Right click on the “Flat Fil
Partitions in SSAS

Partitions in SSAS

Now in analysis services there is a Cube which contains both Dimension and Measure group data. But the important thing in this Cube is partition. Now basically we can say that partitions are nothing but simple object present inside the Cube which holds the complex measure group data. It is like having sub container inside the Cube which we can call

Use Delegate & Threads in factorial program.

Factorial Program using Delegate and Threads. Class Library (FactorialLib): using System; using System.Numerics; namespace FactorailLib { public class Factorial { public delegate void SendResult(BigInteger n); public SendResult WheretoSend; public void Calculate(BigInteger n) { BigInteger result = n; for(BigInteger i=1;i<n;i++) { result = result*i;
Working with “Foreach Loop container” with “Execute SQL Task”

Working with “Foreach Loop container” with “Execute SQL Task”

In this article we will learn how to connect “Foreach Loop container” with “Execute SQL Task”. Starting with the practical, do a drag and drop of “Foreach Loop container” on Control Flow pane from SSIS Toolbox as shown in the below screen shot… Now go to the “Foreach Loop Container” and double click. Go to the “Collection” and
Working with Script Component in SSIS.

Working with Script Component in SSIS.

Script Component can be used in 3 major ways, they are, As a Source, as a Destination & as a Transformation. Now while doing the Script Component tasks and Script Tasks the most important thing is that we are using C# code to do it. We are using C# code because we want to do customize ETL and Non ETL activities. So here are the sample C# codes whic
CDC(Change Data Capture) using SSIS.

CDC(Change Data Capture) using SSIS.

What work does CDC do in SQL Server? CDC means Change Data Capture. The main work of CDC in SQL Server is that it keeps track of all the Inserts, Updates & Deletes happening on a particular Table or on a Particular Database. What is the importance of “_CT” table in CDC in SQL Server? The “_CT” table indicates or keeps track of all the Inser
Learn Factorial in C# step by step.

Learn Factorial in C# step by step.

Factorial function means to multiply a series of descending natural numbers. Example: 5! = 5x4x3x2x1 =125. Example code: ConsoleApplication has been given a reference of Class Library (FactLIB). Here the Class Library (FactLIB) is used to write the logic of factorial. Output: It will be easy to get the result for small numbers, but what if I had to
Create a Job in SQL Server agent to run our XMLA query.

Create a Job in SQL Server agent to run our XMLA query.

This write-up will do a quick discussion on two errors and will propose solution for it while working on SQL Server agent. Error 1:- Now when we tried to create a Job in our SQL Server agent to run our XMLA query and for processing the cube in the background, there were some errors which was encountered by student of MSBI training during practical

Learn simple factorial program.

Create a new Project -> Console Application. In Solution Explorer -> Create a class library to write the logic of Factorial -> give the name as FactorialLib. Class Library (FactorialLib): using System; namespace FactorailLib { public class Factorial { public int Calculate(int n) { int result = n; for(int i=1;i<n;i++) { result = result*i; } return r
How to remove duplicate value while working with Pivot component?

How to remove duplicate value while working with Pivot component?

Over here issue is that SQL table containing duplicate value which in actual it should not have that. We have an error see below screen shot… This is the Error… In order to that, first go to the “Data Flow” and drag “Aggregate” component into the “Data Flow” design pane as shown in the following screen shot… Now configure the “A