One common Question regarding SSIS Interview

  • 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.

  • Please check on this blog:

    http://msbi2012.blogspot.in

  • 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

  • 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.

  • 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)

  • 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

  • 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)

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

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