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
Transformer Records getting dropped
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: Transformer Records getting dropped
what is the data type of RESTRICTED_ACCT_IND you have defined? did you defined the Nullable property as YES or NO?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
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
Accept that some days you're the pigeon and some days you're the statue.