DSXchange

It has both input and output links. But i dont have any parameter defined as the PL/SQL doesnt need any.

The job does a simple insert/update but i need to collect the statistics of the index so that update query is run faster. For this reason, i need to run this statement in between the job.

Hi, I am trying to call the below statement from the Procedure stage. I have not given any procedure name and generate procedure call option is cleared BEGIN DBMS_STATS.GATHER_TABLE_STATS(OWNNAME=>'SVCS',TABNAME=>'STG_COST',estimate_percent => dbms_stats.auto_sample_size,CASCADE=>TRUE); END; This st...

but other posts from you and from your site suggest that you are doing that already. ". I am not doing that currently but thats an idea which is flowing in my project and i am totally against it. So wanted few points to prove that using IPC in every job is not a good approach. Can you Point me...

Can anyone Please confirm the above statement that" using IPC in every job would be very bad as the no. of processes created will be very high and that can bring down the DS performance as a whole?

So i can safely assume that bringing IPC stage in each job will definetely kill the CPU in the sense no. of processes that would be created will be too high?
Regarding the job with 10,000 rows, is it safe to go for IPC or just a direct link from Source to target Oci stage will do?

In our project, we are trying to include IPC stage in each job. is it a good approach? Assuming i have 40 jobs, will there be any resource contention if all the 40 jobs are running in parallel? and if the volume of data in a job is just say 10,000, should we include IPC or a job without transformers...

Unfortunately there are no Administartors here, people do not know what happened on this

6 months back, I used to connect to a DS Server using user name "dsusr1". After that no member in our team used that server, now I wanted to connect to that server and carry out some activities. The server ip is x.x.x.x:9030 . Now I am trying to connect to that server using user id : dsusr...

I am using DS 7.5.2. I need to pass the value of DSPROJECTNAME in Routine activity of a Sequencer. Is this possible. I could not find how to access this variable from a Sequencer. My intention, whenever a mail is sent through mail notification activity, the reader of the mail should know from which ...

Hi Ray, I have given following statement in User Defined SQL. DELETE FROM CENADM.TEST_A WHERE C4<ADD_MONTHS(SYSDATE,-6) and :1=:1 The records are not gettingd deleted as expected. When I execute the comman in TOAD ( DELETE FROM CENADM.TEST_A WHERE C4<ADD_MONTHS(SYSDATE,-6) ),2 records are deleted. W...

I need to execute the following statement in a Datastage Job delete from hist_bucs_shipment where db_upload_date> ADD_MONTHS(SYSDATE, -6); Constraints: 1 It should not be in Before/After SQL 2 It should not done using a Database Procedure, i.e no procedure or function should be exceuted. What is the...

Hi, I am generating surrogate keys using a sequence and trigger in Oracle. During an insert in the table, the trigger is fired and it assigns next value of the sequence to a column(primary key). But it has been suggested that we should use Datastage Sequence generator for the same. So Just wanted to...

Hi, I am generating surrogate keys using a sequence and trigger in Oracle. During an insert in the table, the trigger is fired and it assigns next value of the sequence to a column(primary key). But it has been suggested that we should use Datastage Sequence generator for the same. So Just wanted to...

The following are the jobs which have the problem of displaying error Cannot opne executable file RT_CONFIG<JobNumber> 1. FYearStartDates 2. UCEProcessCtlHistory. I tried to delete them, but could not them. It displays " Cannot open executable job file RT_CONFIG<JobNumber>". Then i renamed...

Yes the size of RT_CONFIG1303\DATA.30 is 0. Actually what happened is One of the developers placed a file of size more than 1GB on Datatage server. So, we are thinking that Server may be out of space. After this activity only, we are experiencing this problems. Is anything related to Space problem. ...