DSguru2B wrote:I understand. But if you change the target to Char. It can handle decimal values. I am not too sure, but give it a shot.
Target is already CHAR and it is Fixed Width file.
Hi Kunal,
You can acheive this by putting spaces in the Null field value option of the sequential file. Just, double click on the field and select the option null field value and put spaces equivalent to width of u r column. i.e if length of u r filed is 10, Put that many spaces in that null field value. I think it will solve u r problem.
NageshSunkoji
If you know anything SHARE it.............
If you Don't know anything LEARN it...............
DSguru2B wrote:I understand. But if you change the target to Char. It can handle decimal values. I am not too sure, but give it a shot.
Target is already CHAR and it is Fixed Width file.
hmm!! in that case I think you are stuck with implementing nulltovalue logic before writing to the file!! I havent seen any general toplevel option that sets it automatically.
if its not fixed witdth file .. when you are specifying default value in column properties, VARCHAR doesnt require you to specify the exact length string .. but CHAR still requires that!!
Actually this is strange, a CHAR column with length 10 (for eg) will always result in 10 bytes when written to a fixed width file, regardless of the datatype of the source.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
The problem is... data is getting rejected at transformer stage.and i am getting warning message as ...[APT_CombinedOperatorController(1),0: Field 'PROCESS_DATETIME' from input dataset '0' is NULL. Record dropped.]
Hi,
Your columns are getting dropped for NULL'S. I think it is better to use "nulltovalue" function for the column or try to replace the column nulls to any value.
The problem is... data is getting rejected at transformer stage.and i am getting warning message as ...[APT_CombinedOperatorController(1),0: Field 'PROCESS_DATETIME' from input dataset '0' is NULL. Record dropped.]
ambasta wrote:The problem is... data is getting rejected at transformer stage.and i am getting warning message as ...[APT_CombinedOperatorController(1),0: Field 'PROCESS_DATETIME' from input dataset '0' is NULL. Record dropped.]
this is different problem .. and covered well on DSX!!
this happens if you are doing any string operations without checking for NULL value ..
in ur sourse file check the nulable col is it defined correctly,i think if a col is nullable and if u specify it as not null then it get dropped i am not sure some body correct me if i am wrong.