Skip to Content
0
Oct 30, 2018 at 03:28 AM

How to merge multiple View using BODS MERGE Transform that have different data type length

1055 Views

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?

Error message:

[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)