SSIS part what transformation you have worked with? lookup and its catch mode merge vs union containers forloop foreach loop sequence data source type you can connect to SSIS how to schedule a job how to call a store procedure in SSIS SQL part top 3rd salary delete vs truncate index( cluster vs non-cluster)

Question

Accepted Answer

Interview questions for SSIS and SQL developer

Worked with Lookup transformation and its catch mode
Understand the difference between Merge and Union transformations
Familiar with containers like For Loop, Foreach Loop, and Sequence
Able to connect to various data source types in SSIS
Know how to schedule a job in SSIS
Able to call a stored procedure in SSIS
Able to find the top 3rd salary in SQL
Understand the difference between Delete and Truncate statements in SQL
Familiar with Clustered and Non-Clustered Indexes in SQL

Popular interview questions of Ssis Developer