You need to reusethe 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 reusethe
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 reusethe
Fuzzy Lookup match index to increase performance and reduce maintenance. What should you do?

A.
Select the GenerateAndPersistNewIndex option in theFuzzy 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:
According to this reference, this answer looks correct.
Reference: http://msdn.microsoft.com/en-us/library/ms137786.aspx



Leave a Reply 1

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


Howie

Howie

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