Reject stage from Trans_stage
In this scenario I am able to reject records to reject file and load remaining records to tgt table if there is no space in || column it is rejecting to reject file
UK ||SUSAN MCCLUSKEY |c/o: FLEMING
But in this scenario it is not rejecting
UK | |SUSAN MCCLUSKEY |c/o: FLEMING
the problem is with space If I keep space while testing it is not rejecting and loading that space to tgt table which is should not do
constarints i am giving in the transformer are
Output link: Src_Input_link.Address_Book_Number <> ''
reject link: Src_Input_link.Address_Book_Number = ''
so need some input how to overcome this problem
I have many coulmns but i posted only 1 column any input
![Sad :(](./images/smilies/icon_sad.gif)