L&T, Chennai - 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 UHG, Hyderabad interview Questions.

       I gathered L&T Software Company’s interview in June 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.       Explain about your project?

3.       When we move packages from one environment to another environment then what would

be the possible errors one can face?

4.       Can we see the variable values of a package at run time?

5.       How can you schedule 20 packages at a time?

6.       Tell me about the Transformations which you used in your project?

7.       How to delete the duplicate values?

8.       How to identify the duplicate values?

9.       How to improve "Merge" Transformation performance? Because "sort" is compulsory and two inputs are must as well.

10.   Suppose i have one package with two tasks. The first task consists of "CheckPoint" and second one does not have? 

       Now, I executed my package then first task is completed successfully and the second task failed when the record count reaches 100. Now, when we re-run the package from which record, insertion will get start?

11.   What are the hierarchies in the SSAS?

12.   What is the use of a cube in SSAS?

13.   What are the subscriptions in SSRS?

14.   What is the use of PIVOT & Un-PIVOT transformations in SSRS?

15.   What are the alternate methods for "count" method to find out number of records in a table?

16.   What is the transformation one can use to load the data in SSAS using SSIS?

17.   What is the use of "Analysis Services Task" in SSIS?