Post reply

SSIS Interview Questions -COMPLEX 1ne

  • May 5, 2010 at 10:16 pm

    #1162935

    Most of your questions are answered here:

    http://www.pinaldave.com/sql-download/DataWarehousingInterviewQuestionsAnswers.pdf

    Regards,

    Manish

  • May 7, 2010 at 3:42 am

    #1163901

    Priya,

    Edit your first post and put the right answers there.

    Rgds,

    Rex Smith

  • June 24, 2010 at 12:33 pm

    #1184651

    Hey Rex,

    I have not recieved exact answers to put into my post, Please provide me I will add them to my post then.

    Its just that I have got an understanding of some pattern to answer the questions.

    [font="Comic Sans MS"]
    ---------------------------------------------------

    Thanks [/font]

  • February 27, 2011 at 8:21 pm

    #1292122

    Hi, did you find job? I am attending to interviews too, please let me know if you know any SSIS questions with answers, thanks in advance.

  • February 27, 2011 at 11:57 pm

    #1292164

    Joshi-400802 (2/27/2011)

    Hi, did you find job? I am attending to interviews too, please let me know if you know any SSIS questions with answers, thanks in advance.

    I have a great question for you:

    Do you have any working knowledge of SSIS and if yes, can you prove it?

    If you can answer that one, you are garantueed to get the job!

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • February 28, 2011 at 1:14 am

    #1292176

    And I urge all those who are interviewing for SSIS positions to be wary of relying solely on the replies to stock questions when assessing technical know-how.

    Unless they are looking to hire parrots.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • February 28, 2011 at 1:16 am

    #1292177

    Koen Verbeeck (2/27/2011)

    -- garantueed --

    Right letters, you just wrote them in the wrong order 😀

    Yeah, I know, it's Monday.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • February 28, 2011 at 1:28 am

    #1292178

    Phil Parkin (2/28/2011)

    Koen Verbeeck (2/27/2011)

    -- garantueed --

    Right letters, you just wrote them in the wrong order 😀

    Yeah, I know, it's Monday.

    Well, look at that 🙂

    Besided from the fact that it is currently Monday, I am also non-native English-speaker, so I am excused of any grammar or spelling mistakes on my part 😀

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • February 28, 2011 at 1:35 am

    #1292179

    Non-native you may be, but your English is still (usually!) better than many native speakers, otherwise I would not have written the post:-)

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • March 1, 2011 at 6:12 am

    #1292851

    Just poking my head into the conversation to say the following:

    I was a hiring manager for a couple years and hired many SSIS developers. As others have stated in this thread, there is no substitute for knowing SSIS. Memorizing the answers to interview questions will only help you get a job with a company that knows so little about using SSIS that they will hire anyone who can memorize answers to their interview questions. Is that the kind of company you want to work for?

    Also - and this is important: I never asked a question in a technical interview, received an answer, and moved to the next question. I always asked questions about the things the interviewee told me in their response (just in case, as crazy as this sounds, someone was trying to josh their way onto my team by memorizing a bunch of SSIS interview question answers).

    :{>

    Andy Leonard, Chief Data Engineer, Enterprise Data & Analytics

  • March 1, 2011 at 2:37 pm

    #1293231

    Hi, Koen Verbeeck

    Yes I do have experience in SSIS, I am using SSIS since last 3+ years.

    Thanks

  • March 2, 2011 at 12:08 am

    #1293353

    Joshi-400802 (3/1/2011)

    Hi, Koen Verbeeck

    Yes I do have experience in SSIS, I am using SSIS since last 3+ years.

    Thanks

    Great, then you should have absolutely no problem with a technical interview about SSIS, I'm sure of that.

    I hope your confidence in yourself is as high as mine 🙂

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • June 6, 2011 at 5:15 pm

    #1334739

    Difference Between the MERGE and MERGE JOIN

    MERGE - similar to JOIN operation. Only joins only two inputs. If there are more than two inputs UNIONALL is used

    MERGE JOIN - select the type of JOIN (LEFT, INNER, FULL) you wish to make.

    Similarities between these two:

    1) Both needs sorted input.

    2) Same i/p type (Int, char)

  • November 8, 2011 at 12:13 am

    #1404281

    4. How often did you DELETE/ UPDATE your FACT tables?I said I never delete from fact I only insert in fact tables they are not satisfied...

    Ans : When ever the package get failed you need to rerun the package, at the time of rerunning you will delete the data which is already there for running date.

    Ex : If you are running the package for 11/09/2011, Package got failed at the end of the package. If your rerunning the package from the SSMS package will run from the scratch until and unless if you put the Check point files in your package.At the time you will look for the today's data in the fact table , If it exists you will delete the data.

    Update : when the fields are getting changed like Address you will perform the update operation.

    5. What BEST practices did you follow in your packages (control flow/data flow)?

  • November 8, 2011 at 12:48 am

    #1404287

    sris84 19444 (11/8/2011)

    4. How often did you DELETE/ UPDATE your FACT tables?I said I never delete from fact I only insert in fact tables they are not satisfied...

    Ans : When ever the package get failed you need to rerun the package, at the time of rerunning you will delete the data which is already there for running date.

    Ex : If you are running the package for 11/09/2011, Package got failed at the end of the package. If your rerunning the package from the SSMS package will run from the scratch until and unless if you put the Check point files in your package.At the time you will look for the today's data in the fact table , If it exists you will delete the data.

    Almost got a heart attack when reading this. Deletes in a fact table? Just because you have to run the package twice? Your package should be intelligent enough to find out that records already exist and not insert them, or alternatively, update them. If you have a checksum check configured, than the package doesn't even have to do the updates, as it will detect that the rows have not changed.

    edit: an even better solution is to incorporate transactions in your package, so that if the package fails, rows that were inserted/updated are rollbacked.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 15 posts - 31 through 45 (of 47 total)

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