Teradata Connector Stage

sachinag · Post by **sachinag** » Mon Jan 31, 2011 5:19 am

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

chulett · Post by **chulett** » Mon Jan 31, 2011 8:25 am

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

sachinag · Post by **sachinag** » Mon Jan 31, 2011 9:22 am

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

Regards,
Sachin Gupta