msbi interview questions

Msbi Interview Questions And Answers For Experienced Pdf

1. What are the Reporting Service Constituents in SSRS?Answer: Report Manager: A Web-based administration tool for managing the Report Server Report Server: Provides services for implementation and delivery of reports. Report Designer: A place where we can create a report. 2. How we can do Error Handling?Answer: SSIS package contains mainly have two types of errors : …

Msbi Interview Questions And Answers For Experienced Pdf Read More »

MSBI INTERVIEW QUESTIONS AND ANSWERS

1. Differentiate between Union all and Merge Join?Answer: Merge transformation can take only two inputs whereas Union all can take more than two inputs. Data has to be sorted before Merge Transformation whereas Union all doesn’t have any foundation like that. 2. What is the control flow?Answer: A control flow consists of one or more tasks …

MSBI INTERVIEW QUESTIONS AND ANSWERS Read More »