Aracılığıyla paylaş

  • Makale

Arama dönüştürme (Gelişmiş Sayfası) Düzenleyicisi

Use the Advanced page of the Lookup Transformation Editor dialog box to configure partial caching and to modify the SQL statement for the Lookup transformation.

Arama dönüştürme hakkında daha fazla bilgi için , bkz: Arama dönüştürme.

Seçenekler

  • Cache size (32-bit)
    Adjust the cache size (in megabytes) for 32-bit computers.The default value is 5 megabytes.

  • Cache size (64-bit)
    Adjust the cache size (in megabytes) for 64-bit computers.The default value is 5 megabytes.

  • Enable cache for rows with no matching entries
    Cache rows with no matching entries in the reference dataset.

  • Allocation from cache
    Specify the percentage of the cache to allocate for rows with no matching entries in the reference dataset.

  • Modify the SQL statement
    Modify the SQL statement that is used to generate the reference dataset.

<div class="alert">


> [!NOTE]
> <P>The optional SQL statement that you specify on this page overrides and replaces the table name that you specified on the <STRONG>Connection</STRONG> page of the <STRONG>Lookup Transformation Editor</STRONG>.Daha fazla bilgi için bkz:<A href="ms189697(v=sql.100).md">Arama dönüştürme Düzenleyicisi (bağlantı sayfa)</A>.</P>


</div>
  • Set Parameters
    Map input columns to parameters by using the Set Query Parameters dialog box.