DSXchange

It may be that the sum of the individual fields may not equal 846. It seems it is equal to 844.

Check your data types on source and target and also check if you are doing the correct type conversions.....

Are you getting any other warnings???

Jay

Its behaving funny ....

I matched both the schemas and am able to populate the target table , finally (sigh of relief!!!)...But i am still getting the warning of "Mismatched schemas"....Column propagation is set to off...

Thanks
Jay

Thanks Ray. I'll keep you posted ....

Hi All, I am getting the following warning at the Transformer stage. TranEmployee_csv: When checking operator: Data set (Virtual dataset; output of "APT_TransformOperatorImplJob_TranEmployee_csv in TranEmployee_csv"; input to "Oracle_217.inEmployeeSort") has preset schema that di...

I had NOT mentioned the database name in the remote server option....

how silly can i become ????????????

damn, i need a vacation....

Anyways, thanks for your time, Ray...

That is what i did.... i have the input string in YYYYDDD format and target is a date in YYYYDDD format.... how do i do the reverse...something like a to_date()....will it work if i do a to_date() in the insert/ update statements.... problem is i cannot test it...i am getting that darn "Oracle ...

Hi All, I am getting the following error. Oracle_217.DSLink203: Error when checking operator: connect failed for env: , user: *****, password: ***** Oracle error: -1034 ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist SVR4 Error: 2: No such file or directory I have done ...

Hi All,

How do i convert a date in Oracle 9i Timestamp format to an Oracle 9i date in YYYYDDD format ?

Without iconv/oconv i am running out of ideas....i tried the TimestampToDate...but i have not been successful so far...

Thanks in advance
Jay

please do a search on Decimal Rounding....hopefully it will help you...

jay

I will be galaxy hopping if i get 28000/hr....

Hi All

I think i am good to go.

I wont be getting such big numbers in the input after all....

Its an hourly rate, so i am expecting it to be small...


Thanks all for your help...
Jay

hi T42, For Varchar to Decimal(8,3), if i do StringToDecimal("12345.678") it gives 12345.000 As far as calculating the divisor is concerned i am doing the following pwr(10.0,len(field(value,".",2))) All but 1 row pass thru. It bombs when input value is: 12345.678. Error is: APT_C...

Hi Ray/Matthieu, Here are the results: StringToDecimal(value)- 1234.000 StringToDecimal(convert(".", "", value)/1000.0) = 1234.567 (if num = 12345.67 then result = 1234.000) StringToDecimal(convert(".", "",value))/1000.0 = 1234.567 (if num = 12345.67 then resu...