• I think the answer to 4 is just fine, I would ask them what they are looking for.

    I would ask for clarification for 5. That isn't a clear question.

    For number 8 look in BOL:

    Merge Transform

    ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/extran9/html/cff8690c-07ac-46a0-aab5-20bd4848c677.htm

    Merge Join Transform

    ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/extran9/html/cd8b0412-f83b-4bd2-b227-e53dcfd941a8.htm

    CEWII