DSXchange

In the oracle table column datatype/length Cust_id not null Number 38 In data stage, oracle stage cust_id not null decimal 38 i specified only the length 38, no need to specify the scale. Any way the scale value will be 0. All the stages in the job, I gave the data type is Decimal and length is 38. ...

In the oracle table column datatype/length Cust_id not null Number 38 In data stage, oracle stage cust_id not null decimal 38 i specified only the length 38, no need to specify the scale. Any way the scale value will be 0. All the stages in the job, I gave the data type is Decimal and length is 38. ...

Hi, I have a job Oracle stage - > transformer - >dataset Oracle Stage: Cust_id decimal 38 not null User deifned sql query: select cust_id from table_name The job is running fine. But it is showing the below warning. Val_ORA: Column CUST_ID floating point decimal is not fully supported; adjusting the...

Hi, The code is working fine in the server but not in the parallel transformer. Iam unable to compile the job in parallel. If any one face the same error please share with me. The compilation error: Output from transformer compilation follows: ##I TFCN 000001 05:22:10(000) <main_program> Ascential D...

The transformer stage contains three stage variables. Stage variable 1: if sal >0 and sal <10000 then 1 else if sal >10000 and sal <20000 then 2 else if sal >20000 and sal <30000 then 3 else if sal >30000 and sal <50000 then 4 else sal = @NULL Stage variavle2: SAL =(SAL*12)/15 Stage Variable3: if ag...

In the server Oracle stage -- transformer -- transformerstage2--oracle stage 10 columns --10 columns --11columns(11th column we are doing some calculation) then passing to the next stage--11columns (11th column we are passing to the routineR1(LINK.COL). The return value storing in to the table. In p...

In the server Oracle stage -- transformer -- transformerstage2--oracle stage 10 columns --10 columns --11columns(11th column we are doing some calculation) then passing to the next stage--11columns (11th column we are passing to the routineR1(LINK.COL). The return value storing in to the table. In p...

Hi, I am doing the server to parallel conversion. I created a routine in the server. Routine name: R1 Input Argument: Arg1 $INCLUDE DSINCLUDE JOBCONTROL.H Call DSSetUserStatus (Arg1) Ans = Arg1 I am using this routine in the stage variable of the transformer stage Stage variable derivation tab: R1(L...

I tried with a sample test the following First i took a column name: Col1 Data type: Decimal Data length: 15 First Stage variable name SONE: DecimalToString(DSLink4.Col1) Second stage variavle name STWO: Length(SONE) Third stage variable name STHREE: STR('0',9 - STWO) The valus is passed to the targ...

I tried with a sample test the following First i took a column name: Col1 Data type: Decimal Data length: 15 First Stage variable name SONE: DecimalToString(DSLink4.Col1) Second stage variavle name STWO: Length(SONE) Third stage variable name STHREE: STR('0',9 - STWO) The valus is passed to the targ...

I tried in this way. i crated a one stage variable which calculates the length of the coulmn. i created one more stage variable which minus with 9. The final integer value will be passed to STR function. value First Stage variable name:sta1 data type: integer Derivation: Len(link.col1) Second stage ...

i tried with that...

it is not returning any rows....

Please give me the solution with the syntax...

Thanks

My source data type is decimal
target data type is varchar

Hi, i am trying with the below function STR('0',9 - Len(DSLink4.test1)) : DSLink4.test1 i am finding the length and minus with 9. the difference will be repated that many times and placed the zeros and finally concatenated with actual value. But i am not getting the zeros, only getting the same sour...

ok fine... my source data is Source 1 2 3 4 5 . . . 100 101 ...so on i want to make the output for that column like this Output 000000001 000000002 000000003 . . . . 000000100 000000101 ........and so on... Please give the solution. How can i convert in parallel. Sorry for keep on asking same thing....