# of column limit in Transformer

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
krystlecsy
Participant
Posts: 50
Joined: Wed Jul 14, 2004 7:56 am

# of column limit in Transformer

Post 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.
Post Reply