DSXchange

Ravi.K wrote:What is the current value for Surrogate key.

The current value for surrogate key is a positive number > 10

Looks like you have hit on a limitation in the stage. Can you convert the decimal to a string prior to the SCD stage and see if that works? ... Ya..on converting the decimal column to integer or string ,it is working fine... But i don't want to do any such conversion..because other jobs with simila...

That column is being used as a SURROGATE KEY in SCD stage

Thank you so much for your response..
I checked the datatype for that column,there is no such conversion and SCD stage is triggering the error as:
SCD_1,0: Fatal Error: APT_Decimal::asIntegerU64: the decimal value is out of range for the integer result.

Hi Experts.. I imported a SCD job in 8.5 from 8.1 Job Desc: Input datasets--->SCD stage-->Ouput Datasets. Here,only 1 colmun in lkp dataset is decimal type as(decimal[38,0]) and rest are Varchar.That decimal column also contains negative value for some records. On running the job in 8.5 it is throwi...

Hi experts, I am using Data stage 8.7. I made a job that contains two sequential files as input to a funnel and a output sequential file... while i am running the job it showing the error as: Contents of phantom output file [1] + Done(139) C:/IBM/InformationServer/Server/DSEngine/bin/NT_OshWrapper.e...

Sorry..it is parallel.... the error is generating in oracle stage only...while i am viewing the data from oracle stage...that time only it is showing the error.... For that reason ,I left all other stages..and used only a oracle stage and wrote the same query as above...and when am trying to view da...

Sorry...i dont know anything regarding PMR :( Yes the job was imported from 8.1... but while i am creating the same job in 8.5 ..still it is showing the same error... like my sql query is as follow: Read Method:Table Table Name:Employee Select clause: Emp_ID,Emp_Name,Designation Where Clause: Design...

Hi Experts..
I am using Data stage 8.5
In Oracle enterprise Stage.. when i am writing where condition with order by in where clause,it is showing error as"Missing right parenthesis"..while this is working in 8.1
Any clue how to fix this problem.