DSXchange

Thaks for your valuable suggestions

Do we need to process all the data or just take sample records and then create a rangemap is sufficient.

Once we create a rangemap can we use the same one even in test,stage and prod and ongoing also do we need to run this process every time before running the main job.

Thanks
dstest

I am processing 1 million records on 4 nodes.In tha parallel job i have join stage so i am doing partion on 4 key columns.Data is not evenly distributing on four nodes becuase some groups have more records and some groups have very less records. In this case I used range partitioning and it is evenl...

Hi Kim,

I tried that query and it is displaying all objects like link names,stage names but it is not giving routine names which i used in the transformer stage of job.

Thanks

I am reading RT_BP809 hash file by using the following routine. TableName="RT_BP809" JobName="JOB.1228413061.DT.148684468.TRANS1" Open TableName To DsJobs else stop "can not open ":TableName Read DsJobsPtr FROM DsJobs ,JobName Then Ans=DsJobsPtr End Else Call DSLogInfo(...

I did a more reasearch on DS_JOBS and DS_JOBOBJECTS, but i did not find any information.I found one record in DS_JOBOBJECTS which is shwoing after routines.But i dont know how can i track if i used a routine in a transformer.

Can any one pelase give me your suggestions how to acheive this.

Thanks

Hi,

Is there any way I can find out If i give routine it will display all the jobs which are using that particular routine by using universe sql query.Give me the table names I can write a query my self.

Thanks
dstest

Hi Ray,

Can you please give me the underlying tables to get this information then i can explore my self.

Thanks
dstest

Hi Ray, Thanks for your qucik reply.For example in a oracle enterprise stage or odbc stage we have a Password property there i defined #TargetPassword# and if there is any way i can find out what is the exact parameter name i defined in this property for all datasbase stages and then i use this para...

Thanks for your replies and suggestions.

Hi, I want to verify like If in a Job if we have Database Stage (Oracle Enterprise,DB2 apI,ODBC --) and the password is parameterised and I want to check whether that is encrypted or not.Can you please suggest if there is any universe qurery to check if there is any database stage in a job and there...

Using Datastage Command Language; In unix when i execute dssh i am getting like below. DataStage Command Language 7.5 Copyright (c) 1997 - 2004 Ascential Software Corporation. All Rights Reserved DSEngine logged on: Sun Oct 5 15:56:53 2008 > Here Can i call routine and get the output from routine.

I would like to know is there any way we can call datastage basic routine through DataStage Command Language.

Thanks

I would like to know which stage is faster compare with fileset and dataset.Becuase both operates in parallel mode and the problem with dataset is it is using more space when compare with sequential file with the same number of records.

Thanks

That means we can only collect those statistics once the sequencer finished only not at the run time.