Modifying the Number of Records Returned - trillium_discovery - trillium_quality - Latest

Trillium DQ Repository Administrator Guide

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Version
Latest
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium DQ Repository Administrator Guide
Copyright
2024
First publish date
2008
Last updated
2024-10-18
Published on
2024-10-18T15:31:00.219841

You can modify the number of records that are loaded when creating an entity pointing to a RDBMS. This is useful when you want to restrict the size of the data that should be fetched. There are two procedures, one specific to Teradata databases.

To modify the number of records that are returned (non-Teradata)

  1. Open ...\MBSW\17\etc\config.txt file. 

  2. Modify the records_read_odbc parameter of the key rdbms section. For example:  

    key rdbms {
       value uncommitted_read "on"
       value records_read 100
       value records_read_odbc 1000
    }
  3. Save your changes. This will return 1000 records.

To modify the number of records that are returned (Teradata only)

  1. Open ...\MBSW\17\etc\config.txt file. 

  2. Modify the max_rows parameter in the key teradata section. (100000 is the default value.) For example:

    key teradata {
       value max_rows 100000
    }

    To return all rows of the database table, set the value to 0.

  3. Save your changes.