DSXchange

Hi, I am getting the following error: ODBC_PR_CUSTOMER: When checking operator: When binding output interface field "PARTY_NAME" to field "PARTY_NAME": Implicit conversion from source type "ustring[max=50]" to result type "string[max=255]": Converting ustring...

Hi, This might help you ;) You have to use following stage variables: svrYear(Int)=If MonthFromDate(RUN_DT) <12 then YearFromDate(RUN_DT) else YearFromDate(RUN_DT) + 1 svrnextMonth(Int)=If MonthFromDate(DSLink2.RUN_DT) <12 then MonthFromDate(DSLink2.RUN_DT)+1 else 1 svrnexttonextMonth(Int)=If svrnex...

Hi All, In our project we are facing some strange problem. The job DS_JOB_user01 has been created by user01, this job is running fine; now there is change request from the bussiness side due to this we have to add few columns in the DS_JOB_user01 Another user user02 has changed the job but user is u...

check the null handling and metadata of the columns.
Are you using direct load or upsert method??

This has nothing to do with individual projects and everything to do with the amount of disk space you have allocated for datasets in your config files. There's no limit other than your hardware. ... Thanks for the reply!! So if the number of datasets are increased, then it will hamper the job perf...

Transformer date format is ISO 8601 standard (YYYY-MM-DD) regardless of project or job default date format. Oh!! :shock: :shock: so even though if we change the project default from %yyyy-%mm-%dd %hh:%nn:%ss to '%dd%mmm%yyyy %hh:%nn:%ss' still it will consider the default value as "%yyyy-%mm-%...

Actually the problem is that we can't use the server job....(we have to develop only parallel jobs... Rolling Eyes ).... That's ridiculous. :shock: FYI: IsValid('Timestamp',StringToTimestamp(DSLink2.Col1,'%dd%mmm%yyyy %hh:%nn;%ss')) The above code with below data did not produce any warnings when i...

balajisr wrote:Why don't you try using Ray's IsValid() routine. You need to develop server jobs to use this.

Thanks of the reply!

Actually the problem is that we can't use the server job....(we have to develop only parallel jobs... )..... I would like to use .....Ray's IsValid() routine.... :D

Hi, Actually there is a issue occured in our project...We want to store the cleanse data into intermedate stage..same as staging table ...initially we were extracting the data from the source and directly loading it into the target tables...but now we have to store the data into some intermediate st...

"11" does not match "%mmm" (which expects three characters). You must get your dates in to a consistent format. ... Thanks for the reply!! :) Actually I want to check whether the Timestamp from the input string IsValid.... So i have used the IsValid function, but the problem is ...

I actually use the above function, the job is giving warning..as Ray has pointed.. for every records ,whose date fomat doesn' t matches with the desired date format. Can you please post those records which gives warning? Hi, Thanks for the reply!! StringToTimestamp(Input.Column,'%dd%mmm%yyyy %hh:%n...

Ray, My project default timestamp format is "%yyyy-%mm-%dd %hh:%nn:%ss" I have two input rows which has to be in format "%dd%mmm%yyyy %hh:%nn;%ss" 1.20Nov2009 14:10:10 2.Nov202009 14:10:10 In the transfomer i have the following code: IsValid('Timestamp',StringToTimestamp(DSLink2...

Hi, We are facing problem in our project , we are using ISValid('Timestamp',InputColumn) to check whether the InputColumn is a valid timestamp or not. The format of the input string is '20Nov2009 14:10:10',but in project default value is %dd-%mm-%yyyy %hh:%nn:%ss. I have unchecked the project defaul...

OK, so what's different about this one problematic server? I'd mostly be curious about the exact Oracle version and the roles/grants the connecting user has there v. elsewhere. ... It's really strange the new server has same configuration as well as same version (Oracle Database 11g Enterprise Edit...

Check whether you have admin priviledge on the base tables. If not, create one table yourself and run against it. ... Thanks for the reply :) As per the suggestion I have created the new table with only two columns and ran the job,but still the job is aborting with error message as : ora_tgt,0: Ope...