Hi All,
I have source fields column name, data_type, Field_size respectively. Suppose if actual value of column=155
Data_type of column=NUMBER
Field_Size of column=40
then I need to load the column value into target as
2000000000000000000000000000000000000155.
So please let me know how to get this.
Thanks
How to find how many digits to concatenate
Moderators: chulett, rschirm, roy
While I am not sure that 40 digits are allowed (38 are), you have two basic approaches to creating your decimal number - either as a string and then convert it, or as a number. I'm also unsure of whether the transform stage compiler will take a 40-digit numeric constants as follows:
but you won't know until you've tried it.
Code: Select all
In.Column+2000000000000000000000000000000000000000
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
In that case:
Code: Select all
In.Number+LEFT("200000000000000000000000000000000000000000",In.Length)
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>