DSXchange

I am slightly puzzled with the datastage full outer join. I have Key fields and values. the full outer join drops off common fiels (other than the key fields , or join fields). Can anyone tell me on what basis it drops the records. Shouldn't it be the other way i.e. dropping common key fields and re...

Check out the Parallel Job Advanced User Guide. According to that, the APT_DEBUG_MODULE_NAMES is used as follows: This comprises a list of module names separated by white space that are the modules to debug, i.e., where internal IF_DEBUG statements will be run. The subproc operator module (module n...

Hi Ray,

Thanks for the information.

If the parameter sets don't have Value Files, then is there any other way to read them instead of going to the project directory.

Thanks

Hi Ray/Craig,

Sorry about that. Yes, the parameter set contains Value Files as well

Yes Ray, it has value fields

Weigh each field with a rank and then sort based on the rank given to that field.

I want to obtain all the Parameters and their Values from a particular "Parameter Set".

I want to do this via Unix. Just similar to
But instead of , I want to obtain from a "Parameter Set" say XYZ

Hi All,

I want to read parameters and their values in Parameter Set via Unix. Is there anyway I could do that.

I tried searching manuals for dsjob, dssearch, but wasn't able to find any.


Thanks

Hi

Does Dsxchange have any plans in introducting DVD regarding the usage of Version 8 (assuming a person knows, server, parallel and quality stage).

Thanks

How can we start the other servers

Hi, We wanted to have users under same group having different permissions. Say there is a group called GROUPA and two users USER1, USER2. We want to have USER1 with Developer permissions and USER2 with Operator permissions. As the administrator will show only GROUPA. How can we implement this? Anoth...

ray.wurlod wrote:Sparse lookup is substantially slower than normal lookup (the latter uses an in-memory virtual Data Set). ...

How can we decide between Sparse Lookup and Join. As both are preferred when normal Lookup is not suitable for the task i.e. heavy on memory.

Hi, I am sorry if I am posting this (or posting this in wrong place). I didn't know where to approach for this question. a) How different is the architecture for both ODI, OWB from Datastage. b) Why do we have two etl tools by oracle (ODI, OWB). I have read that ODI is more used for real-time, is th...

Hi, I have been always reading that if secondary link (i.e. the data being referenced is huge), then go for Join rather than Lookup because of the heavy usage of memory. But what factor determines in choosing between sparse lookup and Join. As sparse lookup does not require heavy usage of memory. Th...

I was going through list of datastage admin tasks and came across some tasks which are new to me. a) shared memory locks - how can we detect/clear shared memory locks by datastage b) internal registry and external registry security settings (such as LDAP) c) regular backup (does this mean only 4 fil...