I have simple job with
Dataset ---> Transformer ---> Teradata Enterprise Stage
Ex: Null Record ---- 1, ABC, 0, NULL, 10
Job is completing with following warning:
"For Trg Col 'A' cannot load with Null so Record dropped."
i.e. Its loading all records except 3 records which has Null in Source col 'A' (Dataset) while loading Trg Col 'A' (Teradata) and all 3 records are getting dropped even though Trg Col 'A' is Nullable column. This is in PX with DS v7.5.2.
Note: In transformer i am doing 2 thing in stage variable
1. StgVar1 = DecimaltoString(Src col 'A', "suppresszero")
2. StgVar2 = if Len(Trim(StgVar1) = 0 then -1 else StgVar1
And after this loading StgVar2 to Trg Col 'A'
But as it was not loading to Trg, So I have tried in Transformer by
adding another stage variable with
3. StgVar3 = if isnull (StgVar2) then setnull() else stringtodecimal(StgVar2)
and then loading
Stagevariable to Trg col 'A'
(Trg col 'A' --> Decimal, len=38 and scale=10 with Nullable)....
But "StgVar3" didn't work.....So, Need help on the same....
![Surprised :o](./images/smilies/icon_surprised.gif)