Page 1 of 1

# of column limit in Transformer

Posted: Tue Nov 21, 2006 7:30 am
by krystlecsy
Hi all,

I am encountering some weird error in the Transformer during compilation.

##W TFCP 000000 20:22:28(007) <transform> Error when checking composite operator: Implicit conversion from source type "Decimal" to result type "DFloat".

Currently, the transformer has 156 number of columns with all Decimal datatype. When one column is removed (with 155 columns remaining), the job compiles perfectly fine. Is there a maximum column limit within a Transformer? Or is there a limit of the number of Datatype in one Transformer? Eg. 155 Decimal datatype, 155 Varchar datatype, etc in 1 Transformer.