You Are Browsing ‘Interview Questions’ Category

Posted on Dec 7 2012 - 7:04pm by roopesh.valluru
Comments Off

Friends, Let’s spend some time here before attending interview on SSRS. This will surely helps you. Questions will keep on adding and hence try to visit this page when ever you have to give an interview on SSRS. • What is Query parameter in SSRS? Query parameters is mentioned in the query of the datasources that are to be included into the SQL script’s WHERE clause of the SQL that can accept parameters. Query parameters begin with the symbol @.The name should not contain spaces and can not begin with numeral. For clarity, we...

Friends, In this post we are gonna discuss about the different interview questions you may face in interviews. I continue to add questions and answers to this post and hence please visit this page regularly to know more and more questions and answers. • What do we mean by dataflow in SSIS? Data flow is nothing but the flow of data from the corresponding sources to the referred destinations. In this process, the data transformations make changes to the data to make it ready for the data warehouse. • What is a breakpoint in SSIS? How...

 What is the difference between SSAS 2005 and SSAS2008? In 2005 its not possible to create an empty cube but in 2008 we can create an empty cube. A new feature in Analysis Services 2008 is the Attribute Relationships tab in the Dimension Designer . to implement attribute relationship is complex in ssas 2005 we can create ONLY 2000 partitions per Measure Group in ssas 2005 and the same limit of partitions is removed in ssas 2008. You can answer more but if you end this with these then the interviewer feel that you are REAL EXPERIENCED.  What...

Friends, In this post I am gonna add stuff related to Interview questions from SQL SERVER with answers. Hope this one will help you in cracking the Interviews on SQL SERVER.  What are Constraints  or Define Constraints ? Generally we use Data Types to limit the kind of Data in a Column. For example, if we declare any column with data type INT then ONLY Integer data can be inserted into the column. Constraint will help us to limit the Values we are passing into a column or a table. In simple Constraints are nothing but Rules or Conditions...

Posted on Feb 11 2012 - 1:11am by roopesh.valluru
Comments Off

Friends, Most important function of MDX is AXIS. The Axis function returns a set of tuples on the specified axis. PFB syntax of AXIS function. “Axis(Number)” Number – is a valid numeric expression which specifies the axis number. The position starts from 0 and it can be continued as the cube database data is MULTI dimensional. MDX query is capable...