WIPRO, Bangalore - SqlServer/MSBI Interview Questions asked by Companies

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

I gathered some of the most important questions that are asked in Wipro’s walk in 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.        Tell me about yourself?

2.        Suppose in my table i have 300 records. In that 300 records i want to update first 100 records with today's date. 101 to 200 records with yesterday's date and 201 to 300 records with tomorrow’s date. How can we do this?

3.        We have 10 sheets in Excel File and 10 sheets contain error data. How to load 9 sheets data in to 1 destination and other error data in to other destination?

4.        Without using multiple sorts how we can sort the data in SSIS ?

5.        Can we declare a variable in SSRS ? If Yes, How ?

6.        What is the connection manager for Loggings in SSIS? Where can we check for the connection managers for all tasks in SSIS?

7.        Suppose I have 10 Packages in Prod Server and now we got one new package created in Development Server and got to be deployed in Prod Server. How to do this? (Without effecting the previous packages)

8.        Difference between 2008R2 and 2012 Deployment process in SSIS and major differences between them.

9.        i have one table in one column

empid

1

2

3

4

5

6

            Now,  I want to show the output as below using SSIS package.  

Empid

'1','2','3','4','5',6'

10.     What are the configurations in SSIS that are stored in local server?

11.     Which type of authentication (protection level) is used in SSIS dts utility deployment?

12.     How to find system user passwords and usernames in Sqlserver?

13.     NOLOCK is similar to which isolation level in sqlserver?

14.     How to delete duplicate records from given table without using CTE?

15.     In my SSIS package, I am using Foreachloop container to load multiple flat files.

Now my requirement is that I want to load only those file which contains %vendor%.

In source folder, I have many files but I am interested in to load only those file which

contains the string %vendor% in file name. How to load it?

16.     I have a table with only one column like

Column A

2000

-1000

4000

-3000

                  Now, I want to show the nagitive and possible values in separate columns without using                    case and decode functions..

17.     I have one package and that package is already scheduled is it possible to apply the transaction for that package?

18.     Suppose, I have one folder with 5 text files. By using for each file enumerator, we store each file in to one folder. But, suddenly tomorrow one more file adds to that folder how to store the file into same destination?

19.     Suppose I have one destination table with some data suddenly 2 excel files data want to insert into the destination table but how to know this data is already inserted into the destination and only new data is inserted into the destination?

20.     My input is

Col

Shashi@gmail.com

Reddy.gmail.com

            My output should be as below. Write a query in sqlserver

Col

sxxxxx@gmail.com

Rxxxx@gmail.com

21.     T1(table)

ID	Name
1	A
2	B
3	C
4	D

T2(table)

ID	Name
1	A
2	B
3	C

          I have 2 tables. But I want to show the output only 4  D row? How to do that in SSIS?

22.     How to truncate a table in dataflowtask ? (without using sql task?)