IBM, Chennai - SqlServer/MSBI Interview Questions asked by Companies

I have started posting a series of sqlserver/MSBI interview questions asked by companies. 

       I attended IBM Company’s interview in Sep 2015.  I have given all the questions which I faced during interview. 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.        What is the difference between primary key and foreign key?

2.        What is the general architecture of ETL project?

3.        Where do you apply the business logic and remove error out records either in stage or source or target?

4.        I have two databases client1.database and client2.database. The table names are like Client1.EmpTarget and Client2.EmpSource. But, both tables have similar structure.

          I used client1.EmpSource table when I am working in the Client1 database and use Client2.EmpTarget table when I am working on the Client2.EmpTarget table.

                 I have written a procedure in the client1 database on EmpTarget table and I want to move the same procedure in the client2 database as well without changing the table names. How can we do that ? ( Ans: Synonyms)

5.       How many indexes are available? Do you recommend to create a covering index on the table? If yes, which scenario, you use it?

6.       How many joins are there? when can we use cross join?

7.       I have a emp table with 100 records and empDetails table with 60 records. I want to know what are all the records that are available in the emp table and not in the empdetails table & available in emp details table and available in emp table. How to find out without  using sub-query?

8.       I have a table with 3 columns like empid, empname and dateofjoining. I want to validate whether the dateofjoining is a date or not in the select query? How will you write a query?

9.     How many UDF are available and how will you call a scalar function in the select query and tabular function in the select query?

10.     What is Parameter Sniffing? How will you correct it?

11.     I have a table with 1 lakh records. The records are validated with the business logic. Now, I want to insert the validation results like column Name and reason into ErroroutRecords table. How will you do that with single query?

12.     What are the steps to create a SSRS report?

13.     You have a stored procedure with if and else condition. The columns returned in the if clause is different from the columns returned in the else clause. Now, I want to create two different datasets in the ssrs report and use those datasets in two tables . How can you do that?