Transfomer is dropping a record when the field has null.
DB --> Xfm-->Lookup-->xfm2..>file
Source has 15 rows. One of the columns in source doesn't have lookup value in lookup table. so it is passed out of Lookup stage.(15 rows) with NULL value. When data passing out of xfm2, only 14 rows are passed out. I tried with putting all columns Nullable to 'YES'. But still I am not able to get through all 15 rows. The row with NULL value is getting dropped out after xfm2. In xfm2, I put
if IsNull(lnk_order.ID) then '' else lnk_order.ID
Transfomer dropping row
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 72
- Joined: Mon Jul 06, 2009 9:34 pm
- Location: Sydney
In addition, not only within a stage variable derivation but if you reference the column in the derivation of another output column. If you do anything with a nullable column other than simply copy it to an output link you need to include null handling logic.
Regards,
Regards,
- james wiles
All generalizations are false, including this one - Mark Twain.
All generalizations are false, including this one - Mark Twain.