HI There,
What should be the Ideal value for properties "Prefetch row count" and "Prefetch buffer size " in Orcale Connector stage?
Search found 16 matches
- Sun Oct 14, 2012 11:21 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Prefetch row count
- Replies: 5
- Views: 6864
- Wed Jan 04, 2012 3:12 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: difference between datastage8.1 and 8.5
- Replies: 2
- Views: 1997
difference between datastage8.1 and 8.5
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 ...
- Mon Mar 14, 2011 10:59 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: row delimiter in column values
- Replies: 3
- Views: 2789
- Mon Mar 14, 2011 10:51 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: row delimiter in column values
- Replies: 3
- Views: 2789
row delimiter in column values
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...
- Thu Feb 03, 2011 6:24 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: what configuration file is used with orchadmin copy?
- Replies: 5
- Views: 3361
Re: what configuration file is used with orchadmin copy?
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...
- Thu Feb 03, 2011 6:19 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Basic Tx in color black when I monitor
- Replies: 2
- Views: 2012
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 ...
- Thu Feb 03, 2011 12:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Basic Tx in color black when I monitor
- Replies: 2
- Views: 2012
Basic Tx in color black when I monitor
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...
- Mon Oct 25, 2010 2:44 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to pass quotes single& double as argument to conver
- Replies: 4
- Views: 4040
- Mon Oct 25, 2010 1:56 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to pass quotes single& double as argument to conver
- Replies: 4
- Views: 4040
how to pass quotes single& double as argument to conver
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?
I want to pass " (double quote) and ' (single quote) as first argument to convert function.
Could some one tell me how to do that?
- Tue Oct 05, 2010 11:27 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to Open OMD.XML.DIR
- Replies: 1
- Views: 1481
Unable to Open OMD.XML.DIR
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?
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?
- Tue Oct 05, 2010 12:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: surrogate key generator stage
- Replies: 1
- Views: 1443
surrogate key generator stage
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.
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.
- Thu Sep 30, 2010 8:25 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Basic Transformer in Parallel Jobs
- Replies: 4
- Views: 2287
- Thu Sep 30, 2010 6:46 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Basic Transformer in Parallel Jobs
- Replies: 4
- Views: 2287
- Thu Sep 30, 2010 5:29 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Basic Transformer in Parallel Jobs
- Replies: 4
- Views: 2287
Basic Transformer in Parallel Jobs
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?
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?
- Tue Sep 28, 2010 11:46 pm
- Forum: General
- Topic: Parallel Routine
- Replies: 1
- Views: 1160
Parallel Routine
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.
I mean can we use ds parallel string function Trim in some custom routine.