Created On:  12 January 2011

Problem:

The impact of the ROWSIZE parameter on the number of UDAs that can be extracted in a Datamart.

Resolution:

The ROWSIZE limitation will only affect the amount of data that can be included in a particular UDA, not in the number of UDAs extracted. By default all UDAs will be extracted. Microsoft SQL Server has a limit of how much data can be inserted into a row. The max row size has a limitation of 8060 characters, which means that if the total number of characters in the UDA's and system attributes combined is more than 8060 for a given row, you will either need to reduce some of the field sizes or decrease the number of projects included in the extraction.