HCL Technologies,Bangalore - SqlServer/MSBI Interview Questions asked by Companies

I have started posting a series of sqlserver/MSBI interview questions asked by companies. Last post, I have posted Sonata Software Solutions, Bangalore interview Questions

       I gathered HCL Technologies, Chennai Company’s interview questions in Dec 2013. I will provide answers to the below questions shortly. Please keep on visit this page for more updates.

Happy Job Hunt!! ALL THE BEST!!

(1)   Tell me about yourself?

(2)   What are the technologies have you used in your Canada project?

(3)   Why do you have used C# in your project?

(4)   Tell me about the tasks you have used in SSIS?

(5)   What are the sources have you used in your project?

(6)   What is the use of CTE?

(7)   What is the use of Table Variable?

(8)   What are the Apply operators and use of them?

(9)    I have a table with a column EmployeeName. The data inside this column is like a, b, c, d etc.

       Now, I want to show the data as row items like a in row1, b in row2, c in row3 etc...

       How can you achieve this in sqlserver?

(10) Write a query to get DepartmentName and highest salary of each department?

(11) Write a query to get second highest salary in sqlserver?

(12) What is the slicing of the cube?

(13) Difference between MOLAP and ROLAP?

(14) Explain me about SSIS Architecture?

(15) How to remove duplicates from a flat file using SSIS?

(16) How to load the data from staging server to data warehouse? And, How to load the data in dimension tables and fact tables?

(17) How frequently you insert the data into data warehouse?

(18) How and where will you maintain last run details when you are loading the data incrementally using SSIS?

(19) How to load the data into fact table?

(20) How will you perform increment load using SSIS?

(21) What is the format of date dimension in your project?

(22) How do you deploy a package in SSIS?

(23) What are the package configurations in SSIS?

(24) How do you handle errors in SSIS?

(25) How do you generate error logs in SSIS?

(26) In which table the log information will get stored if you enable SSIS log provider for Sqlserver?

(27) How to protect a package and what are all the options have you used in your project?

(28) What are the synchronous transformations and Asynchronous transformations in SSIS?

(29) What are the Blocking transformations, Partial Blocking transformations and Non-Blocking transformations?

(30) What are the steps involved in creating a cube?

(31) How to provide a security to the cube?

(32) What is impersonation?

(33) What are the types of Hierarchies in SSAS?

(34) Give me an example for the Un-natural Hierarchies?

(35) What are the relationships available between Fact and Dimension tables?

(36) What is KPI and what are the commonly used properties in KPI?

(37) What are the Actions?

(38)  What are the Perspectives? Can we see the data in a row level or column level when working     with Perspectives?

(39) What is the Derived measure? How will you implement this?

(40) How many types of reports have you developed in your project?

(41)  Have you used Gauges? And, In which scenario, one can go for Gauges?

(42) How to enable the data points in the charts while developing the reports using SSRS reports?

(43)  Write a MDX query using Where condition?

(44)  How to display the alternative rows in red color in SSRS report?

(45)  How to restrict the page contents in a SSRS report's page?

(46)  What are the Physical breaks and Logical breaks in SSRS?