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

[former_member593418]

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)

[former_member187605 · Accepted solution]

Add a Query transform between the _FG_NCM source table and the Merge transform. Map event_type from varchar(6) to varchar(11).

[former_member593418]

Your solution is working.
below is new Data_Flow design.

[former_member593418]

Your solution is working.
below is new Data_Flow design.

merge.png

[former_member593418]

Below show the 2 views under BODS MERGE Transform.

Note on column EVENT_TYPE that have different data length. This design return error as below.

The matching columns of the Merge transform must have the same data type length. (BODI-1111062)

Pls help.