Here you will find "Mixed" level SSIS Interview questions and answers.
Questions are split into 3 levels:
- For Freshers (Beginner Level),
- For Experienced (Intermediate Level - 2 to 3 years of experience) and
- Scenario based questions
SSIS Questions For Freshers
Question 1: What is the difference between Control Flow and Data Flow? [Answer]
Question 2: Name all types of containers in SSIS? [Answer]
Question 3: What is Precedence Constraint and give all available options. [Answer]
Question 4: Name all types of connections you have worked with in SSIS. [Answer]
SSIS Questions for Experienced
Question 5: What is the difference between the following SQL Server connections: OLEDB, ODBC and SQLClient? [Answer]
Question 6: Name all types of transformation you have worked with in SSIS. [Answer]
Question 7: What is the difference between Union and Merge? [Answer]
Question 8: What is the difference between Lookup and Merge Join? [Answer]
Question 9: What is a data flow buffer? [Answer]
Question 10: How can you ensure your package works when you move it to another server? [Answer]
Question 11: How can you deploy SSIS Package (or Project). [Answer]
SSIS Scenario based Questions
Visitors have asked for scenario based real life questions and we have done just that. Visit Scenario Based SSIS Questions.
Question 1: What is the difference between Control Flow and Data Flow?
Answer: Control Flow manages flow of tasks in a package whereus Data Flow most frequently moves data from Point A(s) to Point B(s) and in between often performs transformations, this can get more completed with multiple sources and destinations and more advanced transformations.
Question 2: Name all types of containers in SSIS?
I can't speak highly enough of the quality MSBI materials industry practitioners with varying level of experience and exposure can benefit from this website. Their structured learning plan and courses, DIY projects, webinars and relevant resources go a very long way.
I've gained a whole new perspective on delivering client BI projects to highest standards by employing best practices recommended on this website.
Best quality MSBI training online suite I have used and least expensive too.
Best and affordable BI Training platform in the web.
KEBI Academy doesn't provide training on BI rather their approach is to make you learn BI by yourself.
Self Learning is always the best approach and I recommend KEBI Academy.
You both are doing a great job by sharing your knowledge and experience,
it helps many people who want to learn MSBI from the starting point and also for an experienced person to get to know more about MSBI.
Thank you and keep sharing your MSBI knowledge and experience.
Great work on the videos. I have been enjoying them.