We are getting requirements to add a list of free text (clob) columns from ODS to a table.
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...