DSXchange

HI There,

What should be the Ideal value for properties "Prefetch row count" and "Prefetch buffer size " in Orcale Connector stage?

Hi there, Can any one list out major differences between Datastage 8.1 and 8.5 parallel edition for me. Actually we are planning to migrate from 8.1 to 8.5 , so I wanna know are there any challenges in that or any specific things which need to be taken care off while migration. Quick responce would ...

Yes columns are quoted. If you want I can paste a sample row for you. ID,NAME,TYPE,BILLINGSTREET,BILLINGCITY,BILLINGSTATE,BILLINGPOSTALCODE,BILLINGCOUNTRY 0012000000301zJAAQ,xyz,Licensee,"Level 1 464 High Street",Prahran,VIC,3163,AUS first row is columns names and second row is actual data...

Hi , I have a file for which row delimiter is enter (ascii value 13) . Unfortunately enter (ascii value 13) is appearing in one of the column value as well.Bcoz of this some of the are getting rejected.Could some one tell me how to handle this situation. Please let me know of you need any other info...

When i am trying to copy a dataset it is using a configuration file, (from where it is set not sure?) and due to this it is searching for data files in the resource directory defined in the one being used, Obvisouly there wont be any data files for the dataset i am trying to copy in the resource di...

The BASIC Transformer stage is not a regular Orchestrate operator, so its internal details are not available to the job monitor for parallel jobs. ... Hi Ray, Thanks for your reply. But I have many jobs (regular and multiple instance) with basic transformer in them.It doesn't show status ready and ...

HI, I have a multiple instance job with a basic transformer in it. After running the job when I perform monitor on the instance of the job in director , it shows all the other stages with status finished in color green except basic transfer stage.It shows basic transformer stage with status ready in...

Hi ,

My input string contains double quote and single quote both and i want both to be removed.

input string -"india's"
output shud be indias
i wanna do this using convert function so my question is how to mention single and double quote in first agrument of convert function.

Hi ,


I want to pass " (double quote) and ' (single quote) as first argument to convert function.
Could some one tell me how to do that?

hi,

I have a job with 5-6 stages in it.
when I am running this first time its runs without any warning but if I run it again without changing anything it gives the warning "Unable to Read Temp_<JobName>#12 from OMD.XML.DIR"
Can anybody help?

hi there,
just wanna know answer to below questions....
1.Can surrogate key generate stage handle concurrency like KeyMgtGetNextValueConcurrent() in server?
2. how do we make sure that generated keys are continuous..means there should not be gaps in generated key using surrogate key generated stage.

ray.wurlod wrote:It WILL run on multiple nodes. The main reason for its relative slowness is the need to convert to and from the typeless DataStage BASIC environment to the strongly-typed C++ environment of parallel ...

Thanks Ray....

anbu wrote:BASIC transformer can be used in Parallel job. But the job would run slow

I know it can be used in parallel jobs.
Could you tell me , why it would run slow?
Is it because it wont run in parallel(on multiple nodes)?

Hi There,

Just want to know the downside of using basic transformer in parallel jobs.
would it run slow or would it not run in parallel etc?

Can we use datastage built in function in datastage parallel routines?
I mean can we use ds parallel string function Trim in some custom routine.