get the app get the app       get the app       get the app
You work as a database administrator at Abc.com. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) data flow that adds the data from a source query to a result table for Abc.com. You want to add the rows that are included in the destination table. What should you do? (Choose all that apply)

1)You should consider using a Data Conversion Transformation and a Lookup Transformation.

2)You should consider using a Character Map Transformation and a Term Extraction Transformation.

3)You should consider using a Merge Join Transformation and a Lookup Transformation.

4)You should consider using a Data Mining Query Transformation and a Term Extraction Transformation.

5)You should consider using a Character Map Transformation and a Data Mining Query Transformation.


  • : 273
  • : 9
    Previous Next

    You should consider using a Merge Join Transformation and a Lookup Transformation.

    Suggest other answer
    Login to Discuss/suggest the answer...

  • Exam: 70-448 MS SQL Server 2008, Business Intelligence





    Recommended Learning for you

    Close(X)
    Subscribe here for free mock test on IAS PCS SSC and other competitive exam. Signup here to get SSC CGL Solution and main exam study material