DSXchange

The is a column JN_ADDRESS_OUT.RESTRICTED_ACCT_IND

I am using this column at two locations and these are the transformations

IF ISNULL(JN_ADDRESS_OUT.RESTRICTED_ACCT_IND) THEN SETNULL() ELSE JN_ADDRESS_OUT.RESTRICTED_ACCT_IND

IF NULLTOEMPTY(JN_ADDRESS_OUT.RESTRICTED_ACCT_IND)='Y' THEN '1' ELSE '0'

Some of the records are getting dropped

I did not used the column in constraints

any suggestions

What DID you use in the constraints?

Does your Transformer stage have an Otherwise/Log output and/or a Rejects output link?

sgubba wrote:The is a column JN_ADDRESS_OUT.RESTRICTED_ACCT_IND

I am using this column at two locations and these are the transformations

IF ISNULL(JN_ADDRESS_OUT.RESTRICTED_ACCT_IND) THEN SETNULL() ELSE JN_ADDRESS_OUT.RESTRICTED_ACCT_IND

IF NULLTOEMPTY(JN_ADDRESS_OUT.RESTRICTED_ACCT_IND)='Y' THEN '1' ELSE '0'

Some of the records are getting dropped

I did not used the column in constraints

any suggestions

what is the data type of RESTRICTED_ACCT_IND you have defined? did you defined the Nullable property as YES or NO?
as Ray asked please post more from Log output.

BTW..why you are doing the below? is there anything missing?
IF ISNULL(JN_ADDRESS_OUT.RESTRICTED_ACCT_IND) THEN SETNULL() ELSE JN_ADDRESS_OUT.RESTRICTED_ACCT_IND