SSIS Data Warehouse Development - 101 Interview Questions: Earn over ?50,000 per annum using SSIS and SQL Server by Jack ReynoldsThis book answers 101 essential interview questions that are most likely to appear for a Data Warehousing technical interview using SSIS on a SQL Server database.
The questions cover the following areas:
Data Warehouse Modelling.
ETL (Extract, Transform, Load).
Dimension and Fact tables.
Additionally, there are chapters on how to tailor your resume for a data warehousing role, interview tips to make you appear a stronger candidate and a bonus chapter with a real-world SSIS technical test.
SSIS interview questions
Define SSIS? Name a few SSIS components? Answer: Project is a container for developing packages. The package is nothing but an object. What are the 4 elements tabs that you see on a default package designer in BIDS? Answer: Control Flow: Control flow element is one that performs any function or provides structure or controls the flow of the elements.
SSIS is a platform used for data integration and workflow applications. Question 1. Explain What Is Ssis? Question 2. Question 3. Answer : Solution Explorer in SSIS Designer is a screen where you can view and access all the data sources, data sources views, projects, and other miscellaneous files. Question 4.