DSXchange

Server will be hosted on Unix Box, and acceptable processing time should be about 1-2 hour for daily run for full load. Datastage server should be able to process about 1TB Data in 1 hour or 2 hours maximum, this includes read from sources transform and load the presentation layer.

Thanks ArndW & kumar_w,
The requirement is that the expected data volume handled to be of 1TB and the tranformation and load will be carried out on Datastage Designer. What will be your suggestion based on your experience, we can get the leads from this ?

Hi,
Generally what should be the indicative server and client configuration assuming that we have around 1 TB data flowing through?
Are there any high level sizing guidelines for Ascential Server?
Thanks,

Yeah looks like YOu could get a bit of my requirement :-) I had a routine to read from the parameter file. From your code, I infer that I need to replicate similar code I wrote in my GetParamFromFile routine in the Newroutine2 to read the parameter and add one If condition to look for the parameter ...

:-) Thanks. Now I can use this in a job. :-) I get struck when I have few variable in a routine. Say RoutineTwo which has variables and for these varible I read values from the same parameter file which has set of Parameters as I mentioned earlier and out of them I wish to use ParamName2=ParamValue2...

I do not want to mention the parameters in Sequencer since the DB login and other such info vary from env to env and we wish to avoid editing this way. Hence we call a routine in general for jobs which read from a parmeter file. Now I have another routine which will use parameter so how do i set par...

Thanks dsxdev, Yes I have a file which has parameter and values as ParamName1=ParamValue1 ParamName2=ParamValue2 .. ParamNameN=ParamValueN We have written a routine to read the values and assign to the parameters used in the DStage Jobs, and we call this routine as before job subroutine call, which ...

Thanks dsxdev, Yes I have a file which has parameter and values as ParamName1=ParamValue1 ParamName2=ParamValue2 .. ParamNameN=ParamValueN We have written a routine to read the values and assign to the parameters used in the DStage Jobs. and we call this routine as before job subroutine call, which ...

My question was to know if I can implement the update by Dstage?

The Datamodel and already existing design has it working. We do the task Oracle query by Cognos. We are over to porting DStage environment, Hence I need to achive it in DStage so let me know if you can implement the update. Thanks.

I have this requirement where I have a column named rowid_id which holds the value of rowid of the record. I could not achieve this, hence if anyone has some solution to it. Thanks.

Thanks Ray my code works.

Can we implement UPDATE Table SET col1=rowid ?

Thanks Ray,
I was doing exactly you have mentioned. The stop comes then the required task is to update the same column which appears in the where clause as shown
UPDATE Table SET col1=:1 WHERE col1=:2.

How do I achieve Update as TFM --> Oracle Stage.
Query: UPDATE Meta_Ftp_Adapter SET col1=:1 WHERE col1=:2
Since DStage does not let two columns with same name in the col definitions.

Thanks

Thanks, could you pls explain more, Scenario is: 1) All jobs/routine must read froma parameter file all the paravales as much possible. 2) So I have written a routine which read from these parameter file. Say readfromParameterfile 3) I know now(thanks to you all) how to call this routines from the j...