Here are some relevant Top 21 Interview Questions and Answers for fresher and experienced as mentioned below:
Q.1- Briefly describes SSIS?
ANS- SSIS or SQL (Server Integration Services) is a Microsoft SQL Server component, which helps in achieving the task of migrating data.
Q.2- Mention the important component of SSIS package?
ANS- The main components of SSIS package includes:
- Package explorer
- Data flow
- Control flow
- Event handler
Q.3- Define what do you understand by Solution Explorer in SSIS?
ANS- Solution Explorer in SSIS Designer is a screen where you can access and view all the data sources and other miscellaneous files like data sources protects, etc.
Q.4- Explain what do you understand by the term ‘task’ in SSIS?
ANS- Task in SSIS means same as a method of a programming language that carries or represents unit of work of an individual. Task is been categorized into two categories:
- Tasks of Data Management
- Tasks of Control Flow
Q.5- What do you mean by SSIS package? Explain briefly?
ANS- A SSIS package is an organized collection of connections like data flow elements, event variables, event handlers and parameters, control events and configurations. You can assemble them easily by graphical design tools that are provided by SSIS or you can either build it programming.
Q.6- What is container? How many types of containers are there in SSIS? Explain?
ANS- A container is a logical group of tasks which allows managing the scope of task together. Here are as mentioned 4 types of containers in SSIS:
- Task host container
- Loop container
- Foreach loop container
- Sequence container
Q.7- What do you understand in SSIS “Precedence Constraint”?
ANS- “Precedence Constraint” in SSIS means it is a logical sequence which enables to define you the task, in which manner they should be executed. By connecting connectors like Precedence Constraint, you can connect to all the tasks.
Q.8- Define Checkpoint in SSIS?
ANS- Checkpoint in SSIS refers to allow the failure point of project to restart. The information related to package execution is been stored in checkpoint files, thus if the package runs successfully the checkpoint files is deleted or otherwise it’s start from the failure point.
Q.9- Briefly defines data flow in SSIS?
ANS- Data flow in SSIS is the flow of data from the corresponding sources to target the destinations.
Q.10- List the different types of files that support SSIS?
ANS- These are as:
Q.11- Define Variables in SSIS and its types?
ANS- Variables is used to store values in SSIS. There are 2 types of Variables:
- System Variables
- User Variables
Q.12- What do you mean by SSIS breakpoint? Explain?
ANS- A breakpoint in SSIS enables you to pause execution of the package in business intelligence development studio during troubleshooting.
Q.13- What do you understand by Event logging in SSIS?
ANS- Event logging in SSIS refers to selecting any specific event of a task. It is found helpful in understanding the performance of package during troubleshooting.
Q.14- Define data flow buffer?
ANS- Data flow buffer is a type of an in memory virtual table for holding a data. SSIS usually operates using buffer.
Q.15- In which data in SSIS does Checkpoint Data is not saved?
ANS- Foreach loop containers and for loop containers in SSIS, Checkpoint data is not saved.
Q.16- List the different types of Data viewers in SSIS?
ANS- The different types of data viewers are:
- Column Chart
- Scatter Plot
Q.17- Define what are the possible locations to save SSIS package?
ANS- you can save package in:
- File System
- SQL Server
- Package Store
Q.18- Define the role of Event Handlers Tab in SSIS?
ANS- The role of Event Handlers Tab in SSIS, is to configure the workflow if any tasks stop, fails or starts.
Q.19- Describe the logging in SSIS?
ANS- Logging in SSIS can be by Logging onError to XML, SQL server table, etc.
Q.20- Define “incremental load” in SSIS?
ANS- Incremental load in SSIS in a best and fastest way is by using Timestamp column in the source table and store the last ETL timestamp.
Q.21- Briefly Explain to notify the staff members about package failure in SSIS?
ANS- By setting a notification in SQL Agent when the package runs or by adding a Sent Mail Task in the event handlers we can notify the staff members about package failure in SSIS.
Here are all the experienced and real-time SSIS Interview cracking questions and answers.