DSXchange

Hi, Can you please let me know how to get the previous day row count. Below is the routine we are using to get for the today's row count. can you please help me modify the routine to get previous day routine also. $INCLUDE DSINCLUDE JOBCONTROL.H vJobName = TRIM(JOBNAME) hJob = DSAttachJob(vJobName, ...

Hi Ray, I tried this design also but i am not getting desired output. Universe table --> Transformer --> Hash File --> Target ( unable to fetch the normalize data into target table) Why i want this is : The output of the routine(Transform Function) is giving as a:12,b:13,c:1456,....... I am using th...

How can i implement the same logic if the design consists Universe table --> Transformer -->Target Table .

Here How to apply normalize on target table

Thanks ray. We are using EPM for our Peoplesoft ERP. This is a custom warehouse delivered by Peoplesoft. Its using datastage 7X for all ETL. Since its delivered mart, with all builtin job. It will be hard for us to change all the jobs, also it has more than 1000 jobs. Only change we can do is in the...

We have more than 1000 jobs. Is that any other way to increase the performance of these jobs by without redesigning job.

When you go into the Output tab/Columns tab of the hashed file you will see a column called 'Type', double click it, from the drop down chose 'MV'. The 'Normalize On' option, previously greyed out, should now be availbe. Choose your column that you set 'MV' on from that drop down as well. Hit view ...

All, My Jobs are running fine, its taking 6 hrs time to complete the Nightly ETL Refresh, soon we are going to get 30 times more data. But we have only 8 hrs bandwidth for Nightly Refresh. My Question: How to make datastage use more resources to run faster? like running larger job in multiple proces...

Thanks Dsguru2B,

I had converted the commas using @VM Character It is giving total number of records which are split by commas. But, can you please throw a light on how to do normalize on second column

Hi, I am calling the routine in the transformer the output of the routine is a:12,b:123,c:12345,d:9 .......... The Job design is : Source Table --> Transformer --> Hash File Finally once the job is successfully run the out put of the hash file is ColumnA , Column B JOBNAME a:12,b:123,c:12345,d:9 ......

All,

Can you please let me know how to pass the stage variable output to UserVariables Activity stage.

--
Thanks,
Surya