DSXchange

Hi Craig, Thanks you , no prob's. What about in server jobs can this be done. Regards, Rajeev Prabhu Sorry, not a PX guru... just remember stuff I see posted. :? Someone else will have to help with the gory details. Or you could search through the forum again for those keywords, I doubt it's the fir...

Hi, I am working in Windows verion of DS 7.x, i want to know how a user can be given acess to DS Client, i have created a user group at NT level and i see that group in DS Admin->Properties of project-> Permision and given them DS Developer role, but i am not able to connect to the Project by giving...

Hi Crieg, That was great, but i have a doubt. See i am having 42 jobs and all are independent jobs, and all are one to one direct load. But of these tables that i am loading one is huge table we will have 1 million rows populated per day, in case the jobs get aborted in between, i want to know till ...

Hi Kim, But i have a doubt, how will i make use of this in my jobs, can you give me the details how to go about it. Regards, Rajeev Prabhu You could download EtlStats.zip from ADN or my tips page. It posts all the row counts to tables in the warehouse but you could easily write these to a text file....

Hi, Thanks you Kim. Regards, Rajeev Prabhu You could download EtlStats.zip from ADN or my tips page. It posts all the row counts to tables in the warehouse but you could easily write these to a text file. You get all the jobs and create table statements. It posts link names and row counts. Very simp...

Hi,

Thank you.

Regards,
Rajeev Prabhu

l_homme_de_rio wrote:it's an Oracle Pb, try to redesign your query by using explain plan or ask DBA assistance
(Try explain plan first)
All the best

Hi, I am having a job which loads data from oracle table using ORAOCI and loads the data into the staing table stg_accounts, and uses a tranformer to check for null values in columns and puts the data to table with another ORAOCI to write the data into the Oracle databse. But while running i am gett...

Hi Vincent McBurney, Thank you for your reply. So we can do it, that is good. Only thing is Path any other issues, regarding the Parallel process of jobs, can this be done or will we have to independently change the options. Regards, Rajeev Prabhu Just export your jobs from the Windows server and im...

Hi, We are developing some server jobs in Windows platform of DS 7.1r1, but later on we want to integrate these jobs in DS 7.1r1 parallel extender option, in unix enviornment, what is the over load on this and what all precautions do we have to take care when you desing jobs in windows and then put ...

Hi Vignesh, Thanks you. But since i am new to Datastage, i have a doubt how can i write or take data after executing this DS routine in the after job routine, and also what will happen in the job got aborted will this after job routin execute. Regards, Rajeev Prabhu You can do everything right from ...

Hi Vignesh,

Thanks you.

Can we populate this data into a text file and take this data for our use.

Regards,
Rajeev Prabhu

vigneshra wrote:You can make use of DSJobReport routine to capture the audit information about a job and it can be called from after-job subroutine.

Regards,
Vignesh.

Hi Kenneth Bland, Sorry i put the words wrongly, we are working in windows platform in DS 7.1r1, later we want to convert into Parallel because we are having only windows server ready, Unix server will be ready in few days or in a week, so what we have decided is to do the work on windows and later ...

Hi, We are developing some jobs in Windows platform, but later on we want to integrate these jobs in DS 7.1r1 parallel extender option, in unix enviornment, what is the over load on this and what all precautions do we have to take care when you desing jobs in windows and then put it to parallel. Reg...

Hi, I am having 42 jobs and we want keep track of the follwoing details like Job name, no. rows read, no. of rows written, no. or rows rejeted, start time of the job, end time of the job and its status of each job into a sequential file. Can you help me in doing this, can it be done in one generic j...

Hi, Thank you for your suggestions and i will go through it. Regards, Rajeev Prabhu Have you ever develop in any programming languages before you are using DataStage? If not, I would suggest that you learn one, so you can have a better understanding on passing parameters, and other functions. DataSt...