warnings when changing the data type

[thumati.praveen]

hi all,


i am changing the datatype of my input column timestamp to string,it is generated error like;

xfmLoadData,0: Conversion error calling conversion routine timestamp_from_string data may have been lost

can u provide the solution...

thanks inadvance
praveen

[balajisr]

What is the length of the destination string?

[thumati.praveen]

What is the length of the destination string?

i dont specify the length.

[Nageshsunkoji]

Hi Praveen,

In which stage you are performing this converison either Transformer or Modify stage. Use the Proper syntax for that in the above stages. If you are perfoming this in any satge without any conversion, then it will throw error to you.

In Tarnsformer :
TimestampToString Return the string representation
of the given timestamp
timestamp[format (string)] result (string)

In Modify Stage :

stringField = string_from_timestamp
[timestamp_format | uformat](tsField)

Hope It will Help.

[thumati.praveen]

Hi Praveen,

In which stage you are performing this converison either Transformer or Modify stage. Use the Proper syntax for that in the above stages. If you are perfoming this in any satge without any conversion, then it will throw error to you.

In Tarnsformer :
TimestampToString Return the string representation
of the given timestamp
timestamp[format (string)] result (string)

In Modify Stage :

stringField = string_from_timestamp
[timestamp_format | uformat](tsField)

Hope It will Help.

hi nagesh,

i am using at transformer stage ,conversion function is timestampTostring function i am using,i got warnings like

1)xfmLoadData,3: Conversion error calling conversion routine timestamp_from_string data may have been lost

2)xfmLoadData,2: Conversion error calling conversion routine timestamp_from_string data may have been lost

3)xfmLoadData,1: Conversion error calling conversion routine timestamp_from_string data may have been lost

these three warnings only and i am getting the output data perfect.

what is the problem in this...can u find.

thanks inadvance
praveen

[thebird]

Can you try doing a trim of your string before giving it to the conversion function - and let us know if the warning still persisits?

[thumati.praveen]

Can you try doing a trim of your string before giving it to the conversion function - and let us know if the warning still persisits?

thanks for ur input
the problem is solved by me,in transformer stage at source field i specified the length.


thanks
praveen