You need to reuse the Fuzzy Lookup match index to increase performance and reduce maintenance

You are designing a SQL Server Integration Services (SSIS) package that uses the Fuzzy Lookup
transformation. The reference data to be used in the transformation does not change. You need to
reuse the Fuzzy Lookup match index to increase performance and reduce maintenance. What should
you do?

You are designing a SQL Server Integration Services (SSIS) package that uses the Fuzzy Lookup
transformation. The reference data to be used in the transformation does not change. You need to
reuse the Fuzzy Lookup match index to increase performance and reduce maintenance. What should
you do?

A.
Select the GenerateAndPersistNewIndex option in the Fuzzy Lookup Transformation Editor.

B.
Select the GenerateNewIndex option in the Fuzzy Lookup Transformation Editor.

C.
Select the DropExistingMatchlndex option in the Fuzzy Lookup Transformation Editor.

D.
Execute the sp_FuzzyLookupTableMaintenanceUninstall stored procedure.
E Execute the sp_FuzzyLookupTableMaintenanceInvoke stored procedure.

Explanation:
Reference:
http://msdn.microsoft.com/en-us/library/ms137786.aspx



Leave a Reply 2

Your email address will not be published. Required fields are marked *


on Yahoo

on Yahoo

Always make sure that an SEO agency is open about their methodologies used – any secrecy could mean they are using “black hat” techniques. This can be done in a number of ways including regular press releases and blog posts. Every website on the internet is aiming for long-term promotion and visibility on search results, and hiring a competent SEO consultant which uses white-hat techniques can certainly help in achieving that goal.
on Yahoo http://www.115mov.com/space-uid-21504.html