Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

One common Question regarding SSIS Interview Expand / Collapse
Author
Message
Posted Friday, September 21, 2012 8:56 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 3:17 AM
Points: 194, Visits: 1,089
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.
Post #1362742
Posted Monday, September 24, 2012 12:10 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 15, 2013 11:49 AM
Points: 48, Visits: 269
Please check on this blog:
http://msbi2012.blogspot.in
Post #1363669
Posted Tuesday, September 25, 2012 7:54 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 1:53 PM
Points: 1,166, Visits: 1,194
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
Post #1364050
Posted Tuesday, September 25, 2012 11:33 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 11:14 AM
Points: 535, Visits: 1,651
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.
Post #1364198
Posted Tuesday, September 25, 2012 1:45 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 4:53 PM
Points: 36,795, Visits: 31,257
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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1364271
Posted Tuesday, September 25, 2012 3:18 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:18 PM
Points: 6,175, Visits: 7,253
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
Post #1364309
Posted Tuesday, September 25, 2012 7:09 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 4:53 PM
Points: 36,795, Visits: 31,257
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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1364394
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse