Fuzzy Lookup Transformation Editor (Reference Table Tab) Use the Reference Table tab of the Fuzzy Lookup Transformation Editor dialog box to specify the source table and the index to use for the lookup. Related Tasks For details about how to set properties of a data flow component, see. From the drop-down list, select the secondary table, and then select the corresponding fuzzy match column. Select the column you want to use for your fuzzy match. The Merge dialog box appears with the primary table at the top. For more information about the properties that you can set in the Advanced Editor dialog box or programmatically, click one of the following topics. You can also select Merge Queries as New. Configuring the Fuzzy Lookup Transformation You can set properties through SSIS Designer or programmatically. In addition, if the Fuzzy Lookup transformation maintains the match index-that is, if MatchIndexOptionsis set to GenerateAndMaintainNewIndex-the transformation may lock the reference table for the duration of the data cleaning operation and prevent other users and applications from accessing the table. By doing this, you can prevent the lookup queries from consuming resources on the production server. If the reference table that the Fuzzy Lookup transformation uses is on the production server, you should consider copying the table to a non-production server and configuring the Fuzzy Lookup transformation to access the copy.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |