SQL Ssis Developer Interview Questions and Answers

Answers to SQL/SSIS Developer interview questions

• To delete duplicate records in a table, you can use the DELETE statement with a self-join or a subquery.

• The number of indexes in a table can be determined by querying the system catalog views or using database management tools.

• A sequence is an object in SQL Server that generates a sequence of numeric values. It can be used to generate unique identifiers while inserting rows into a table.

• To use a sequence while inserting rows, y...read more

In SSIS, you can manage different sets of columns in two files by using conditional splits and dynamic column mapping.

• Use a conditional split transformation to separate the data flow based on the file type or column presence

• Create separate data flows for each file type and handle the columns accordingly

• Use dynamic column mapping to map the columns dynamically based on the file type

• You can use expressions and variables to dynamically handle the column mapping

• Handle any additio...read more

Pivot in SQL server is used to transform rows into columns, based on a specified column value.

• Pivot is used to rotate rows into columns

• It requires an aggregate function to be applied on the values being pivoted

• The PIVOT operator is used in conjunction with the SELECT statement

• The PIVOT operator requires a unique identifier column and one or more columns to pivot

• The PIVOT operator can be used to perform dynamic pivoting as well

SSIS packages can be deployed using SQL Server Management Studio or the dtutil utility.

• Deploy using SQL Server Management Studio by connecting to Integration Services, right-clicking on the SSISDB folder, and selecting 'Deploy Project'.

• Deploy using dtutil utility by running a command like 'dtutil /FILE C:\SSISPackages\Package.dtsx /COPY SQL;Package /DESTSERVER serverName /COPYFILE SQL;Package /Q'.