DSXchange

Hi Ray,

The stage throwing error is SybaseOCPX. May be beacsue of any patches ?

Hi, We have been facing an issue with one of our job in production as this job running scuccessfully from longtime and failed today for the below reason. Fatal Error: Fatal: Plug-in stage property (SOURCE_TABLES) is not defined for Input Links Can you please help to identify the issue. Thanks, Satee...

Hi, We are using Dataset in one of the jobs. We are using the update policy as "Overwrite" for Dataset.This job is running fine but some times we are getting like below. Unable to open descriptor file to update: Permission denied Error updating ORCHESTRATE File Dataset descriptor segment i...

Satish,

You can use even parallel job but you have to verify two things

1. Check whether you rae using proper key columns in job based on the table definition

2. Put the execution mode of the job in sequential.

Regards,
Sateesh.M

Chulett,

Thanks for the reply.

I have to populate last calendar date of the month that i am getting from input.

For Exapmple Input record is 2008-12-27 then need to popultae '2008-12-31' in end_date column.

Regards,
Sateesh.M

Hi I have to populate "last calendar date" in end_date column Source : Varchar Targget : Date I am doing in the below way END_DATE[1,4]:'-':MonthFromDate(END_DATE)+1:'-':01 SvarDt1 JulianDayFromDate(SvarDt1)-1 SvarDt2 DateFromJulianDay(SvarDt2 Svardt3 End_date=Svar3 I am getting the follwo...

hi all,
how to eliminate first two rows from source seqential file

thanks
Stheesh bab

Hi ArndW,

I tried in such a way you told but the same thing is happening,

The length i am getting from input is 9 when i use len(Col) ,and both my output and input column lengths are same.

Hi, The source data is like this M'Sateesh and the column is of varchar2(9) in both source and target but when i am trying to load the data it says "value too large for column actual: 10, maximum: 9 eventhough it is coming 9 from input. When i tried to insert this value in database using statem...

Hi, Our team is designing a job in which we are using surrogate key generator [In parallel mode] .It is being used to generate value for the key column "User_ID". Problem :: After using this stage , the User_ID does not appear in sequence. We want it to be in a sequence. PLEASE SUGGEST SOM...

Hi, I am getting the below warning on my oracle table, When binding output interface field "stae_cd" to field "state_cd": Implicit conversion from source type "int32" to result type "int16": Possible range limitation. Actually i am getting this stae_cd from sq...

hi,

Adding to my old post i am able to insert data using column export i.e spcifically to length of around 50,If it is more than that it is being truncated but i specifed length varchar2(1000).

Thanks for your inputs.

Sateesh.M

Ray, You are right ,the problem is with columnexport only.Actually from input when we are exporting all the columns to a single column,If any special characters are coming then that particular data is not being inserted properly into database where as if we load to sequential file then it is being i...

Hi,


In column export i am using Final delimiter as end and Filed Delimiter string as \| ,In the same way i am doing from columnimport

Delimiter for field "Student" not found
Import was unsuccessful at record

What could be the reason.

Thanks for your time

Sateesh.M

Hi Ray, Thanks for your suggestion and i got to know how to call sequence value in target database,But the thing is that i want to generate the unique value for all the three target table columns ,How could i achieve this. In my target insert query i am calling oracle sequence like seq.nextval. Than...