SSIS Questions frequently asked in Infosys interviews:
1. What is checkpoint in SSIS and how do you configure a checkpoint?
2. What are transactions?
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjBmDMEKUMkZKNLRqX79qm-JNBWGLUbzNWPRq2YAP0fuI5I3x5a4OnF6Q8ZtSIz-9qxfi8dHrb7rrynz9iLPa9xpxtndbkSe4O6t6CRJBuYt91JpkBuwj6ugPL6z8nHLDKNIFZRdee9Ags/s200/Infosys1.jpg)
3. How do you define transactions in SSIS?
4. What is logging in SSIS and how do you log events?
5. What is CDC (Change Data Capture)?
6. Explain how do you automate CDC?
7. How you will test the SSIS packages?
8. After data loading, what will you test?
9. Given a scenario to define ER Model for the scenario like “A College is organizing a Band”.
10. Prepare the necessary Model with required attributes.
Tags: SSIS Interview Questions and Answers At Infosys, Infosys, Interview Questions and Answers At Infosys, SSIS, SSIS Interview Questions, SSIS QA, SSIS Interview Questions and Answers, SSIS Tutorial, SSIS books, SSIS Interview Questions pdf, SSIS experienced QA, interview questions, SSIS interview questions for experienced, SSIS interview questions for developers,SSIS interview questions for freshers,SSIS interview questions senior level, SSIS Certification Questions, Basic SSIS interview questions, SSIS interview questions 2 3 4 5 6 years experienced, SSIS Real time interview questions, SSIS Interview Questions and Answers At Infosys 2015, Latest SSIS Questions At Infosys Interview.
1. What is checkpoint in SSIS and how do you configure a checkpoint?
2. What are transactions?
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjBmDMEKUMkZKNLRqX79qm-JNBWGLUbzNWPRq2YAP0fuI5I3x5a4OnF6Q8ZtSIz-9qxfi8dHrb7rrynz9iLPa9xpxtndbkSe4O6t6CRJBuYt91JpkBuwj6ugPL6z8nHLDKNIFZRdee9Ags/s200/Infosys1.jpg)
3. How do you define transactions in SSIS?
4. What is logging in SSIS and how do you log events?
5. What is CDC (Change Data Capture)?
6. Explain how do you automate CDC?
7. How you will test the SSIS packages?
8. After data loading, what will you test?
9. Given a scenario to define ER Model for the scenario like “A College is organizing a Band”.
10. Prepare the necessary Model with required attributes.
1 comments:
Write commentsThrough this post, I know that your good knowledge in playing with all the pieces was very helpful. I notify that this is the first place where I find issues I've been searching for. You have a clever yet attractive way of writing on Msbi online training
ReplyMsbi online training Hyderabad
Msbi online training India
Msbi online course
Msbi course
Msbi training
Msbi certification training