We have come up with few real-time questions asked to one of the fresher candidate during MSBI(SSIS, SSAS and SSRS) interview questions if you are one of those who is seeking for the same then below questions and answers will surely help you. 1. Is SQL Server required for MSBI Development? Yes, SQL Server is required for MSBI Development. 2. What components did you use in SSIS package development? We did use many components is SSIS like Conditional Split, Merge, Merge Join, Sort, SCD, CDC, Data Conversion, Execute Task component, Script Task, etc. 3. What is the difference between Merge & Union All? They are both transformations of SSIS. The first difference between them is that Merge can only accept two datasets as input while Union All can accept multiple datasets as input. The second main difference is that Merge requires both datasets to be sorted while Union All does not require sorting of the datasets. 4. What is an MDX query and give its sample query? MDX Query is used to retrieve information stored in an OLAP Cube.


I guess you came to this post by searching similar kind of issues in any of the search engine and hope that this resolved your problem. If you find this tips useful, just drop a line below and share the link to others and who knows they might find it useful too.

Stay tuned to my blog, twitter or facebook to read more articles, tutorials, news, tips & tricks on various technology fields. Also Subscribe to our Newsletter with your Email ID to keep you updated on latest posts. We will send newsletter to your registered email address. We will not share your email address to anybody as we respect privacy.

This article is related to
 
MSBI,MSBI Interview Question,Uncategorized,Learn msbi step by step,msbi class room training in mumbai,msbi training,SQL Server,step by step