SSIS Questions frequently asked in Infosys interviews:
1. What is checkpoint in SSIS and how do you configure a checkpoint?
2. What are transactions?
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:
1. What is checkpoint in SSIS and how do you configure a checkpoint?
2. What are transactions?
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.