DSXchange

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

I have an Oracle stage with only one column ID(Decimal 15) and i am looking up on ID in another Oracle stage with 3 columns ID(decimal 15), DATE(decimal 15) and DW_ID(decimal 15). Then the data is loaded into the target table. The lookup has no condition and the lookup failure condition is set to DR...

I have a string (20080301) which i convert to 2008-03-01 using StringToDate function in the transformer stage.
i want the output in the format 01/03/2008

I am specifying absolute paths and not just the file/script name. For ex. :/prop/llb/tng/bin/ECS_SPLITTER/ECS_Employer_File_Splitter.sh is the path for the script secified in the Input value box after selecting Exec SH from the after subroutine drop down list. Also in the UNIX script i have used abs...

I have a script in the after job subroutine in Job Properties. The path given is correct.I have used Exec SH option from the drop down list. Even then when the job finishes the script is not getting executed, but when i run it in UNIX it runs successfully. What might be the solution to this? I am ge...

I have a script in the after job subroutine in Job Properties. The path given is correct. Even then when the job finishes the script is not getting executed, but when i run it in UNIX it runs successfully. What might be the solution to this?

I meant to say that 1 column in the input is to be divided into 3 columns in the output in a transformer stage.Even if i remove AsInteger i am getting data related warnings.I think i should put some default values and check. The next stage is a funnel and then i am populating a DataSet and DB2 table.

In a transformer i am trying to divide the input column (DECIMAL) into three otput columns(INTEGER). I am using AsInteger(linkname.colname) but getting an error as 'Operator terminated abnormally: received signal SIGSEGV'. Can anyone help me out?