Steps to Reproduce :-
Expected Results :- The attribute column in DWH tables of this object should be populated with the 400 - 500 values
Actual Results :- The attribute column in DWH stores a truncated version of the values.
Release : 16.0.3
This is caused by the limitation of VARCHAR/VARCHAR2 data type. They can only store data worth 4000 bytes.
To prevent the failure of DWH job, if the combined values exceed 4000 bytes we are capping the values to 3995 bytes. Any value exceeding this will not be stored in the DWH tables.
This is not a defect and is working as expected.