Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kkiranvr
Yak Posting Veteran
54 Posts |
 Posted - 2009-04-20 : 17:03:52
|
| An example of what the flat file would have would be billed amt: 8500, paid amt: 5700The way it should look in the claim fact table should be billed amt: 85.00, paid amt: 57.00So, what needs to be happening when we bring the values in is that we need to be starting at the right and go left two digits and then insert a decimal. What we don’t want to happen is bring in the data and then add a decimal and another 2 zeros.-Thanks N Regards,Chinna. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-04-20 : 17:11:35
|
Make a calculated column, which could divide the value with 100.0E before continue the data flow.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
|
|
|
Decimal value problem