DSXchange

Hi,
is it possible to install Datastage 7.1 server, director, manager and designer in a pc without unistall DataStage 5.2?

I' d like to have both version in the same pc.

thanks in advance

Regards

Mario

Hi,
unfortunately the same parson that run the job would like to stop it clicking the "stop" button in Director. In this case is impossible to avoid the commit, right?

thanks

Hi, Sometimes it is necessary to stop a running job that is writing in an oracle table. In this case the job do a COMMIT before to stop all activities. In our job we have TRANSACTION HANDLING set to 0 because we want the commint at the end of the run. Is it possible to configure the job or the DataS...

Hi, i have an aggragator that must aggregate 20M of records but it abort. I suppose that can be a memory problem. If the aggregator manage until 6-7M of record work well. Over this amount don't work. How can i resolve this problem? i tried to use the sort plug_in but it is very slow. Can the sort pl...

Thanks for the suggestion about the use of a flat file, but I'd like to know if it is possible that a batch return a value like a function.

thanks

Mario

Hi,
in a datastage project I have s a batch (name A) that is attached and runned by an another batch (name B).
After the end of the run of the batch A, can A return a value to the batch B?

thanks in advance

Mario

Hi Cheers, in the past I resolved performance problem with hash file and i can help you but it is necessary that you answer at 2 questions about the hash file: how many field have the key of the hash file? And about the variance of data in each field in the key? Is high or low? I'd like to know coun...

Hi,
i'd like to use an oraoci8 plug_in with the option "User Defined SQL Query File" because i have a very complicated query.
i set the options... but:
where can i specify the name and the directory of file with the query?

tanks in advance

Mario Loreti

funnel stage?
which is the funnel stage? The merge stage is only for file, right?

Mario

Hi, it is possible to load the data without user defined query but with 2 jobs (simpler to implement but difficult to manage) or 1 job (more difficult to implement but easier to manage ) first solution job 1 -> load the data from remote host (table A) to local table in your host. You must set "...

Hi, I want to read the dsx file (or XML, is the same) because i'd like to write a program that 1) can determine the resources used (file, oracle table etc) in order to calculate the execution precedences 2) extract the oracle query 3)plot the data traffic i can't use metastage because the job's are ...

Hi, i'd like to read all information contained in a dsx file (an export of a DataStage's project). I created the file with the only option "Job define" in the export tool. In the file there are a lot of reserved words. Can anyone tell me where is possible to find documentation about them a...

Can anyone tell me where i can find tha list of bug fixes the several versions of Datastage to leave from the 5.1?

Thanks
Mario

hi, i use DataStage 5.1 and ORACLEOCI8 plug_in. i created 2 table in a Oracle DB with following script: CREATE TABLE ETL.SORGENTE_ML ( CHIAVE VARCHAR2(30) NOT NULL, VALORE NUMBER NULL ) CREATE TABLE ETL.DESTINAZIONE_ML ( CHIAVE VARCHAR2(30) NOT NULL, VALORE NUMBER NULL ) SORGENTE_ML is the source ta...

Hi Vincent, thanks for your suggest. I try this solution (i tried it in the past too) but don't work. I modified the job and selected the Update action "Insert new rows or update existing rows" and all work fine. i tried to change the update action to "User-defined SQL" with the ...