I am getting error as below when merging 2 Views (from database) using BODS MERGE Transform that have different data type length.
I have no control over maximum data length of column returned by view from database.
Attached showed the design of my Data_Flow.
Any solution on this?
[Merge:Merge] Length <6> for column <EVENT_TYPE> (schema type <Tran Merge input ..._FG_NCM>) does not match the length <11> of column <EVENT_TYPE> (schema type <Tran Merge input ..._FG>). The matching columns of the Merge transform must have the same data type length. (BODI-1111062)