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

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.