free text columns

Database
Enthusiast

free text columns

Hi All,

 

We are getting requirements to add a list of free text  columns from ODS to a table in Teradata 

Potentially that will result in 5-6 columns of type varhcar(2000) or varchar(4000).

They may or may not be populated all the time.

This is a fact table.

Please share if there are performance concerns if we keep the text columns (wide varchar columns) as part of the fact table or should we consider storing in an extension table.

 

need help as I need to implement them...