get the app get the app       get the app       get the app
The package includes a Data Flow task that copies several million rows. The data flow requires a match against a reference table that contains 10,000 rows. Each row in the reference table will be used during the data flow.

Same row are not matching due to a mismatched case type

You need to ensure that the data flow executes to match all rows correctly.

Which data flow component should you select?

1)A Fuzzy Lookup transformation

2)A Lookup transformation along with the Full cache option

3)A Lookup transformation along with the No cache option

4)A Lookup transformation along with the Partial cache option


  • : 197
  • : 0
    Previous Next

    A Lookup transformation along with the No cache option

    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