DSXchange

It seems that the samething u can achieve through DS_JOBS and DS_JOBOBJECTS table as well. But not sure the join condition on these tables. Need to investigate. Wait for sometime. Sure someone will post on it. Thanks Subrat In version 7.x you click on "Usage Analysis" in Manager, having se...

Can you please give me an example how to do it?

Thnaks
Subrat

chulett wrote:If you are looking for a macro, a job can find out what is 'calling' it using the DSJobController macro. Same as via the DSGetJobInfo() function using the DSJ.JOBCONTROLLER Info Type. ...

Hi, I have a list of 1000 DS jobs. I need to know the sequence name for each of these datastage job which callling it. e.g: Suppose datastage job is "Job_ABCDE", then i want the sequence which calling it. Sequence_ABCDE--------->Job_ABCDE. It seems we can do it by write a routine calling t...

Thanks Ray for the suggestion. I got the relevent information from earlier post. Thanks again. I described fully in my earlier post how it works. Premium membership costs less than 30c per day, and allows one (among other things) to read all of what premium posters have to say. Premium membership is...

Thanks Ray... U mean to say at Run time we need to pass value to the $PROJDEF parameter? Is this environment var defined in the configuration file. If yes then whats the default value. Thanks $PROJDEF is one of three special tokens that you can use to set the default value of a job parameter that is...

Hi,

Why we use PROJDEF parameter and whats the utility of this parameter. The question seems to be silly one bt as i am new to this tool so expecting ur help on this.

Moreover what is "Orachastrate"?

Thanks

ray.wurlod wrote:Why not prove it either way? Run the job with Force set and not set, capturing and examining the Score. Which one has no copy operator? (Note that the Copy stage must be a straight-through copy (no ...

For my scenario it s giving me the same output in both case.

In DS Manuals it says " If we keep the Datastage Force property option set as true then Datastage internaly optimize the job by removing copy operation." In my case.. i know i have two output from the copy stage. So isnt be good if i keep the Force option as False.

Thanks

Hi,

In Copy stage whats the difference if i keep the set Force option as True or False.

I have a Job where there are one input and two Output to copy stage. In this case shall i keep the Force option as True or False and why?

Thanks

Hi,

Whats some key differences between Local Container and Shared Container.

Which one is better to use: Shared container ot Shared Routines. and why?

Thanks

Hi,

I am new to DS. Can anyone let me know the utility of $PROJDEF and why we use that? Whats the differnce between User Var and Env variable.

Thanks Ray for this valuable info... Can u please also suggest me if we are doing hash partioning, is it always better to take all table keys as partion keys also? If yes then can i do same thing for other type of partion as well... Moreover in case of join, lookup etc... are the data match within t...

Hi,

Can anyone tell me how configuration file work in a DS environment. What kind of information are there inside the Config file.

Thanks
Subrat

Could u please briefly explain whats mean by 'which always returns the same uint32 value'. Moreover can a processing node contain more then one partion? You identify the key column(s). The characters from those columns are used as input to a hashing function, which always returns the same uint32 val...

Hi

Can anyone help me to understand how Hash partioning is happenening in parallel Job. How the key is generating?

Subrat