SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


One common Question regarding SSIS Interview


One common Question regarding SSIS Interview

Author
Message
Smash125
Smash125
SSC Veteran
SSC Veteran (283 reputation)SSC Veteran (283 reputation)SSC Veteran (283 reputation)SSC Veteran (283 reputation)SSC Veteran (283 reputation)SSC Veteran (283 reputation)SSC Veteran (283 reputation)SSC Veteran (283 reputation)

Group: General Forum Members
Points: 283 Visits: 1381
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.
sumit.joshij
sumit.joshij
SSC Journeyman
SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)

Group: General Forum Members
Points: 84 Visits: 269
Please check on this blog:
http://msbi2012.blogspot.in
robert.gerald.taylor
robert.gerald.taylor
SSCommitted
SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)

Group: General Forum Members
Points: 1796 Visits: 1490
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
Ed B
Say Hey Kid
Say Hey Kid (695 reputation)Say Hey Kid (695 reputation)Say Hey Kid (695 reputation)Say Hey Kid (695 reputation)Say Hey Kid (695 reputation)Say Hey Kid (695 reputation)Say Hey Kid (695 reputation)Say Hey Kid (695 reputation)

Group: General Forum Members
Points: 695 Visits: 1787
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
Jeff Moden
SSC Guru
SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)

Group: General Forum Members
Points: 86041 Visits: 41095
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.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Evil Kraig F
Evil Kraig F
SSCrazy Eights
SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)

Group: General Forum Members
Points: 8597 Visits: 7660
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 | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables

Twitter: @AnyWayDBA
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)

Group: General Forum Members
Points: 86041 Visits: 41095
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.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search