SSIS Interview Questions and Answers Part 4

Posted on May 19, 2015 by uday arumilli

SSIS_InterviewQuestions_4

SSIS – Part 4

SSIS Interview Questions and Answers for Experienced and Freshers

Here we are publishing series of posts on SSIS Interview questions and answers Part 4 for experienced and freshers. Below is the series 4.

Q. Difference between Union–all and Merge Join?

Ans:

  • Merge transformation can accept only two inputs whereas Union all can take more than two inputs
  • Data has to be sorted before Merge Transformation whereas Union all doesn’t have any condition like that.

Q. What is difference between Multicast and Conditional Split?

Ans:

The Multicast transformation distributes its input to one or more outputs. This transformation is similar to the Conditional Split transformation. Both transformations direct an input to multiple outputs. The difference between the two is that the Multicast transformation directs every row to every output, and the Conditional Split directs a row to a single output

Q. What is the difference between DTS and SSIS?

Ans:

Continue reading →

Posted in MSBI, SSIS | Tagged , , , , , , , , , , , , , , , , , , | 2 Comments

SSIS Interview Questions and Answers Part 3

Posted on May 18, 2015 by uday arumilli

SSIS Interview

SSIS – PART 3

SSIS – Performance Tuning

SSIS Interview Questions and Answers Part 3

Here we are publishing series of posts on SSIS Interview questions and answers Part 3 for experienced and freshers. Below is the series 3.

Q. How to quickly load data into sql server table?

Ans:

Fast Load option: This option is not set by default so most developers know this answer as otherwise the load is very slow.

Q. What are the fast load options available in SSIS?

Ans:

Continue reading →

Posted in Interview Q&A, MSBI, SSIS | Tagged , , , , , , , , , , , , , , , , , | 2 Comments

SSIS Interview Questions and Answers Part 2

Posted on May 18, 2015 by uday arumilli

 SSIS Interview Questions

 

SSIS – Part 2

SSIS Interview Questions and Answers for Experienced and Fresher’s

Here we are publishing series of posts on SSIS Interview questions and answers Part 2 for experienced and freshers . Below is the series 2.

Q. What is a breakpoint in SSIS?

Ans:

A breakpoint is a stopping point in the code. The breakpoint can give the Developer\DBA an opportunity to review the status of the data, variables and the overall status of the SSIS package.
Breakpoints are setup in BIDS. In BIDS, navigate to the control flow interface. Right click on the object where you want to set the breakpoint and select the ‘Edit Breakpoints…’ option.

Q. Can you name 5 or more of the native SSIS connection managers?

Ans:

  • OLEDB connection – Used to connect to any data source requiring an OLEDB connection (i.e., SQL Server)
  • Flat file connection – Used to make a connection to a single file in the File System. Required for reading information from a File System flat file
  • ADO.Net connection – Uses the .Net Provider to make a connection to SQL Server 2005 or other connection exposed through managed code (like C#) in a custom task
  • Analysis Services connection – Used to make a connection to an Analysis Services database or project. Required for the Analysis Services DDL Task and Analysis Services Processing Task
  • File connection – Used to reference a file or folder. The options are to either use or create a file or folder
  • Excel
  • FTP
  • HTTP
  • MSMQ
  • SMO
  • SMTP
  • SQL Mobile
  • WMI

Q. How do you eliminate quotes from being uploaded from a flat file to SQL Server?
Ans:

Continue reading →

Posted in Interview Q&A, MSBI, SSIS | Tagged , , , , , , , , , , , , , , , | 7 Comments