DSXchange

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

thx Craig.
Do you see any concerns using ODBC vs using dedicated SQL server stage ..performance, parallelism wise? Thanks in advance

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?

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 ...

ray.wurlod wrote:SCD is a regular stage type, it sits right there in the processing stream. ...

Is SCD available in V7.2 ? or just from V8.0 onwards ?

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...

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...

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...

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...

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...

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...

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...

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

Manager/DataSet Management.....

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,...

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

In transformer you can define a stage varibale and use GETENVIRONMENT["VariableName"] and the stage variable, this way carries the value for the job.