One common Question regarding SSIS Interview

Question

Post reply

One common Question regarding SSIS Interview

Smash125

Hall of Fame

Points: 3562
More actions
September 21, 2012 at 8:56 am

#262715

Its been while have not given any interview SSIS.Just preparing my future course of action
One common questions that comes to my mind is
Explain SSIS architecture? My answer may differ from others answer. What Suggestion would you give or what should be the approach.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

sumit.joshij Ten Centuries Points: 1040 More actions · Answer 1

sumit.joshij

Ten Centuries

Points: 1040

September 24, 2012 at 12:10 pm

#1541559

Please check on this blog:

http://msbi2012.blogspot.in

robert.gerald.taylor SSChampion Points: 13133 More actions · Answer 2

Smash125 (9/21/2012)
Its been while have not given any interview SSIS.Just preparing my future course of action
One common questions that comes to my mind is
Explain SSIS architecture? My answer may differ from others answer. What Suggestion would you give or what should be the approach.

I'd explain the role of SSIS and how it fits into a typical ETL. From there, I'd ask the interviewer specifically what more they want to know.

MS has some info at: http://technet.microsoft.com/en-us/library/ms141709(v=SQL.90).aspx

HTH,

Rob

Ed B Hall of Fame Points: 3666 More actions · Answer 3

I would talk about differing philosophies of the role of SSIS. Some people love it and want to do everything in SSIS, while others use it as a framework for executing stored procedures.

You could mention whether you like lots of small packages controlled by a master, or if you like one big package. You can talk about whether you have worked with a package framework using shared logging and error handling etc.

Personally I like to do as little as possible in SSIS because I find it much easier to read sql than to infer logic by clicking on objects, however, I have begrudgingly acknowledged that SSIS lookups can be faster than SQL updates when assigning multiple surrogate keys to large volumes of data.

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 4

Smash125 (9/21/2012)
Its been while have not given any interview SSIS.Just preparing my future course of action
One common questions that comes to my mind is
Explain SSIS architecture? My answer may differ from others answer. What Suggestion would you give or what should be the approach.

So what would your answer actually be right now?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Evil Kraig F SSC Guru Points: 100851 More actions · Answer 5

Smash125 (9/21/2012)
Its been while have not given any interview SSIS.Just preparing my future course of action
One common questions that comes to my mind is
Explain SSIS architecture? My answer may differ from others answer. What Suggestion would you give or what should be the approach.

So, out of curiousity, what is SSIS architecture? Are you talking the underlying construction of it, the way to build selective data pathing, transformation components, error components, configurability, expressions construction, error row considerations? That question is so open ended you'd probably stunlock me into a few dozen questions to try to figure out what you were trying to ask.

Also, are you trying to give an interview and looking for good topics, or are you expecting to interview for a position and want an idea of what to brush up on? Those are two very different approaches, even though they look the same on paper.

Someone looking for good topics or questions I'd be able to provide a few particular questions to and if they have enough knowledge would extrapolate that into the necessary questions in an area, so they wouldn't be holistic, they'd be particular conversation spark points they'd be able to use to start guaging an applicant's real knowledge as they expanded off the answers the interviewee gave. If you're looking to interview, I can offer high level topics that you'll want to have general knowledge of and you'll have to dig into all the different applications of that knowledge, which means practice and experience.

I'm not sure which way you're trying to go here.

- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 6

Actually, if you do what anyone going on an interview should do for these types of doubts is show just a little prowess with Google. Search for "SSIS architecture" and be amazed. I would expect any and every candidate to be able to find the answers to these types of questions. It's just not that difficult. All you have to do is try.

Similar MS documentation is also available in Books Online. Lookup "SSIS" in BOL and then scroll down 4 lines and click on the word "Architecture".

I'd also expect a candidate to be proficient in being able to use Books Online.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)