DSXchange

DataStage 7.5x2 installs MKS Toolkit, which has its own telnet service, which grabs port #23. Consequently the DataStage telnet service is blocked from using port #23. However, you can establish a telnet connection; you get the UNIX prompt ($) and can do all kindsa UNIX things, including invoking Da...

Yes, with field marks (@FM) between them. In this way you have constructed a dynamic array, in which each element will be interpreted as a separate line by the shell.

How did you calculate row size? Remember that (a) hashed files store data in dynamic arrays, and (b) there is storage of approximately 14+N bytes per record (where N is the number of fields), 22+N if 64-bit addressing is enabled. Sainath's question is pertinent. Hashed files do not automatically giv...

Just out of curiosity, were these interview questions?

Can you change the column derivation to specify an explicit cast of the INTERVAL HOUR TO HOUR data type so that it returns an INTEGER? Then simply declare an Integer in your DataStage job. The column derivation would read

No. Dynamic hashed files' properties really only affect write speed; you may find that a perfectly tuned static hashed file has better read speed when the file is large. There's one exception to this. If you're doing an existence check only (existence of the key value), then a very small LARGE.RECOR...

saadmirza wrote:Thanks Ray,
Yes it does matter for the performance...but does it really matter for the functionality....because i am still not convinced even after lots of testing...

Please suggest..

Thanks,
SM

No, it's like a fuzzy inner join. Inner joins are commutative.

I didn't see any mention of training/certification sessions...

Mayhap DCS could offer a "transition from server to parallel" session?

Most support providers are fairly OK about supplying manuals and white papers, in my experience. Have you tried asking your support provider?

There are five manuals (in PDF format) for ProfileStage, totalling 10.2 MB.

Decimal and Numeric have a fixed number of decimal places and can therefore be represented exactly in the machine using scaling (within the bounds of machine precision). Real and Double have an arbitrary number of decimal places and no guarantee of accurate storage at the limits of precision can be ...

(Rev? Well, that will keep Roy a little happier!) There are two ways to install plug-in (= optionally installed) stage types. One is to install them when installing the DataStage server. By choosing them then they are installed into the Template from which new projects are created. The other is to i...

What is the exact version of DataStage? What is the exact version and service pack of the operating system? Activities in job sequences can appear to hang if there are very many objects of that type in the Repository. This is more usually seen with jobs than routines, since most sites don't have tho...

You should not try to move plug-in stages in this way.

You should install them properly in the other project either when DataStage server is installed on that machine or using the Package Installer.

This ensures that they are properly registered.

It's not an error, even though it displays as a warning after you export. The good news is that it's not a problem either. Read-only objects are, by default, the ones that ship with DataStage, so they will be present in any project into which you import the contents of this export file. They are omi...

The resource (process) was temporarily unavailable. This suggests that your machine is overloaded or that the process table was full at the time. Don't overload your machine.