DecimalToString conversion

[r.bhatia]

Hi,

I am facing the following problem in data transformation

The source is an ebcdic file,

1. source column details:
column name : AB_CD
column attribute : Decimal(1,0)
column value : 1

2. Transformation details:
straight mapping
even tried DecimalToString(AB_CD)

3. target column details:
column name : YY_ZZ
column attribute : char ( 8 )
column value : "1."

The problem is the additional "." which I am getting in the output, the same is propogating after load to the database.

How can I get rid of the "." charater, I need "1" as the output.

[ray.wurlod]

Decimals have decimal placeholders. End of story. If you want an integer, specify an integer data type.

[ArndW]

Convert(Link.YY_ZZ,'.','') will remove the period.

[r.bhatia]

Thanks Ray for the prompt reply.

As I have mentioned my source is an ebcdic file.

In ebcdic representation integer is internally stored as binary and decimal is internally stored in packed decimal format.

since i am reading them using Complex flat file, i read this source field as decimal and cannot read as integer as per my understanding.

So how can i do the conversion from decimal to integer and then charater? in oder to get the desired output?
Any pointers?

Thanks!
Rakesh

[jaideepbakre]

HI,
Use AsInteger() function in the transformer stage.
I guess you will get 1 as the output.