how to convert Square_feet into Square_meter
Moderators: chulett, rschirm, roy
how to convert Square_feet into Square_meter
how to convert Square_feet into Square_meter
in my source file one column in square_feet i need to convert into Square_meter when loading data into the target.
i know 1 square feet=0.0929 square meter
i taught by using transformer 0.0929*square_feet column=square_meter
this is possible or any other methods.
can any one help.
in my source file one column in square_feet i need to convert into Square_meter when loading data into the target.
i know 1 square feet=0.0929 square meter
i taught by using transformer 0.0929*square_feet column=square_meter
this is possible or any other methods.
can any one help.
ANJI
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
In a server job or in a BASIC Transformer stage you can use the SDK Transform MeasureAreaSqFeetToSqMeters.
Detail of its transform definition:
Otherwise just multiply by the constant. Make sure that the Sq Feet value is not null and is numeric, so as to prevent errors. Since square metres is always less than square feet, and a negative value of square feet is technically impossible, you don't need to detect/handle arithmetic overflow if the target data type matches the source data type.
Actually, there is at least one possibility where negative might be valid, in a time series - a question like "how much area does $1000 buy now compared with five years ago?" - but the square metres value will still be closer to zero than the square feet value.
Detail of its transform definition:
Code: Select all
(%SqFeet% * .09290)
Actually, there is at least one possibility where negative might be valid, in a time series - a question like "how much area does $1000 buy now compared with five years ago?" - but the square metres value will still be closer to zero than the square feet value.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
I NEED IN PARALLEL JOBSray.wurlod wrote:In a server job or in a BASIC Transformer stage you can use the SDK Transform MeasureAreaSqFeetToSqMeters.
Detail of its transform definition:Otherwise ...Code: Select all
(%SqFeet% * .09290)
ANJI
Doing it in a transform stage is the simplest way. You could write your own c++ buildop to perform this conversion but it would be a lot more work than using the transform stage.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
HERE SOURCE IS FLAT FILE TARGET IS INFORMIXSainath.Srinivasan wrote:What is the problem you are facing ?
Is it giving incorrect values or you need to know how to do the coding ?
If you are using a database as our target, you can create an user-defined SQL to cal ...
SOURCE FIELD IN SQUARE_FEET IN TARGET I NEED IN SQUARE_METER
MY LOGIC GIVING IN CORRECT VALUES
ANJI
First thing - typing in all caps is considered SHOUTING so please knock that off. There's no need to shout.
Secondly, show us. Post the 'calculation' you are using and the precise datatypes involved and then show us the 'in correct' values you are seeing. Then maybe someone can help you.
Secondly, show us. Post the 'calculation' you are using and the precise datatypes involved and then show us the 'in correct' values you are seeing. Then maybe someone can help you.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 138
- Joined: Wed Jul 16, 2008 9:51 pm
- Location: Kolkata
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: