DSXchange

Hi Team,

My job flow is like below

Seq File --->Transfomer---->Teradata Connector Stage

I im passing two values from my file as '0' & '1',based on these values i want to execute DDL written in the teradata Connector stage.

I am using constraint in transformer as if value equal to '0' than execute the DDL.

This is working fine if I am using DROP statement in connector stage as when I am passing '1' my DDL is not getting executed and my job is not getting aborted.

But same thing if i am doing with CREATE statement my job is failing and getting aborted if I am passing '1' as a value.

Please help me this.


Regards,
Sachin Gupta

Post your constraint. And where in the Connector is your DDL?

I am using User Defined SQL in connector stage to Run my DDL Statements

Regards,
Sachin Gupta