Is there any upper limit for the ODBC Connector stage to run in parallel. ie. At any point in time, how many parallel connection [Bulk Load] to SQL Server can happen? 8.5x/Linux is the environment.
Thanks in advance
Search found 193 matches
- Tue Jan 24, 2012 9:56 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DS 8.5 sequel server stage
- Replies: 8
- Views: 4604
- Sat Jan 21, 2012 1:53 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DS 8.5 sequel server stage
- Replies: 8
- Views: 4604
- Sat Jan 21, 2012 11:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DS 8.5 sequel server stage
- Replies: 8
- Views: 4604
DS 8.5 sequel server stage
Hii know there is oracle stage and I assume that.there is no dedicated Sequel server db stage.. Is the only option to use ODBC connector..if so does it provide parallelism?
- Fri Mar 12, 2010 1:17 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Decimal field suppressing leading and trailing zeros.
- Replies: 1
- Views: 3051
Decimal field suppressing leading and trailing zeros.
Hi, Working on DS after a while and finding it tough to achieve this result. I have a source & destination field Decimal 15,2 When the amount field is zero, I should have 0.00 When the amount field is 12cents, I should have 0.12 When the amoutn field is 5dollars, I should have 5.00 In the abvoe ...
- Mon Nov 10, 2008 2:06 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How can u implement the SCD's in Parallel jobs in datastage?
- Replies: 8
- Views: 6481
- Sun Nov 09, 2008 5:49 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DataStage as an ETL to loadinto Oracle's E-Billing product
- Replies: 3
- Views: 3291
I don't see why not, as all you're going to find under the covers are POOTs - Plain Old Oracle Tables. Should just be a matter of retrieving the metadata and knowing how the tables map / relate to eac ... Thanks Chulett. I understand your point and that's what my thinking is to. But I'm just trying...
- Sun Nov 09, 2008 3:58 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DataStage as an ETL to loadinto Oracle's E-Billing product
- Replies: 3
- Views: 3291
DataStage as an ETL to loadinto Oracle's E-Billing product
Hi, There's this new development in our project going on w/ the purchase of Oracle Product eBilling ver 6.0 which has Oracle Warehouse Builder [OWB] inbuilt which is an ETL to load data into the product. But we are exploring options if Datastage could be used instead of OWB. [Licensing costs more fo...
- Tue Jan 29, 2008 5:06 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Determine DayofWeek in Job Sequencer
- Replies: 4
- Views: 3070
Hi Vijay, Where did you find @DAY? You can use the ExecuteCommand stage to execute a unix command to find the Day and then use the output (Execute_Command_0.$CommandOutput) in the NestedCondition activity to find if it is Friday or not and then move on from there. HTH --Rich Thanks Rich..I'll try i...
- Tue Jan 29, 2008 8:50 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Determine DayofWeek in Job Sequencer
- Replies: 4
- Views: 3070
Determine DayofWeek in Job Sequencer
Hi, I have a sequencer in which I have to notify by email a certain task. During Friday this should be sent to one set of receipients while it's run any other day, to another set of receipients... I have a 'Nested Condition' Job Sequencing Activity to determine and branch out two different "Not...
- Mon Jan 28, 2008 8:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Float to Decimal in Buildop - Rounding Problem
- Replies: 3
- Views: 5169
Where do you imagine the third decimal place is going to be generated from? You've summed numbers with a scale of 2. There is no third decimal place. ... Ray, you have a 'good' point...Yes all my input $ Charge fields are Decimal 15,2 which gets aggreagated into a Total amount which is again a Deci...
- Fri Jan 25, 2008 10:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Float to Decimal in Buildop - Rounding Problem
- Replies: 3
- Views: 5169
Float to Decimal in Buildop - Rounding Problem
Hi, I have a rounding issue. Here's the scenario All my amount fields are Decimal 15,2 and after summation ends up in Decimal 15,2 which when done with an Aggregator nicely rounds off. Then we had to replace the Aggregator with a Buildop wherein we have defined as Float [15,2] as Input and Float [15...
- Tue Jan 22, 2008 12:30 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Why and Why?
- Replies: 7
- Views: 5385
Re: You asked for it
Castigation Notes One question per thread please. It makes it easier for future searchers. For the same reason please try to use a meaningful subject. Please get the details right. APT_DISABLE_COMBINATION is an environment variable, not an operator, and its name is given in all upper case. Properly...
- Tue Jan 22, 2008 12:28 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to count he number of records in a dataset
- Replies: 9
- Views: 11581
Re: How to count he number of records in a dataset
Manager/DataSet Management.....kool78 wrote:Any ideas on how to get eh count of number of records for a dataset.
i tried to look for the 'orchadmin' commands but didnt find any help.
thanks
- Tue Jan 22, 2008 12:27 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Upgrading to 8.0 ..Things to be looked at
- Replies: 4
- Views: 2875
Upgrading to 8.0 ..Things to be looked at
Fellow DSers, If we were to upgrade to DS Version 8.0, from developer's perspective, apart from exporting/importing the code, recompiling, and ofcourse, testing, would there be any other tasks that might be involved that would take up some considerable time. [Our application has the following: Jobs,...
- Fri Jan 18, 2008 9:12 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to call a environment variable in a job level
- Replies: 2
- Views: 1933
Re: How to call a environment variable in a job level
In transformer you can define a stage varibale and use GETENVIRONMENT["VariableName"] and the stage variable, this way carries the value for the job.balu124 wrote:Hi ,
can any one suggests how to call a environment variable in the job level that is already defined at the project level