SSIS – INTERVIEW QUESTIONS

1.  Package Configurations: IF SQL Server Package Configuration, How do implement it    and what are the things need to change when moved to other    Environments.
2.  Get file names from the folder using SSIS. (Can use ForEach loop Container and Change the propery to only "file Name" or "File and Extension")
3.  Debugging SSIS Packages. (Can use Breakpoint functionality in package)
4.  Logging in SSIS.
5.  We have crores of records in source, then what we need to do load into target table fast?
6.  What are steps will you implement to improve performance in SSIS?
7.  Difference between OLE DB Destination and SQL Server Destination.
8. Difference between Data Access modes "Table or View" type and "Fast Load" type in SSIS.
9. Explain about SCD in SSIS ?
10.  An Employee table has data with different departments. How will you store the employees of particular department in to each department text file? Like Sales department employee should go into Sales.txt file etc.
11. Have multiple Excel files in folder. You need to load all into a DB table?
12. Do you have any experience in creating a new component in SSIS ?
author

Kiran Reddy A

Kiran has been a part of the IT industry for more than six years and Involved in many MSBI projects and product development with extensive usage of ETL and Reporting tools like SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Service (SSRS) and T-SQL

Get Free Email Updates to your Inbox!

2 comments

What is the best casino site? - Lucky Club Live
The first thing we want to focus on is that it's a real-money casino, luckyclub.live which means that there are no online casinos for you to choose from.

Reply

www.CodeNirvana.in

Powered by Blogger.

Translate

Total Pageviews

Copyright © Journey to MSBI World With Kiran Reddy | Blogger Templates | Designed By Code Nirvana