DSXchange

Character map translations are performed at the boundaries between DataStage and the "outside world". Within DataStage everything is managed in a UTF encoding of Unicode. Therefore (since a Transformer stage is not on any such boundary) there is no need to perform any character mapping in ...

When you specify "called by", do you mean "actually run from" the job sequence (note: it's not "sequencer") or do you mean "appearing in the design of the job sequence but may or may not be invoked depending upon the logic in the job sequence"? For a single jo...

I think you should investigate the Slowly Changing Dimension stage.

lakshman978_dsx wrote:Hi Gurus,

Can you pls. tell me a procedure to delete hash files from a unix (AIX) box to save memory.

DS Version: 7.5.1 - Server Edition
OS: IBM AIX

Thanks in advance,
~ Lakshman

Deleting hashed files will not save memory.

Hashed files are not resident in memory unless they are in use.

Depends. Is the same key likely (or even possible) to occur more than once in your input stream of new data?

Why not use the Slowly Changing Dimension stage, which manages all of this in a memory-mapped image of the target table?

In almost all cases, not only the hashed file will be created but so too will its file dictionary (a static hashed file whose name has "D_" as a prefix). The file dictionary and the VOC entry (if any) must also be deleted for the hashed file to be regarded as properly deleted. If the hashe...

The space character is used (instead of "+") to indicate a non-negative value, as this is the "natural" representation for humans.

Have you read the Parallel Job Advanced Developer's Guide ? The available API calls are documented there. Note, though, that dsjob is a command, not a function library. Indeed, it began life as an example of how to call the DataStage API functions from C. Now it is fully supported, though its source...

DataStage has no problem at all preparing data for Oracle. People who write incomplete or incorrect specifications are the source of the "problem". Oconv(TheDate,"D-YMD[4,2,2]") : " " : Oconv(TheTime("MTS:") will generate what you asked for, given internal for...

It depends on the context, and whether you have NLS enabled. These characters are what are known as the "dynamic array mark characters" - that is, they are the special characters used to delimit elements in dynamic arrays. In general processing they can usually be handled satisfactory, but...

Does nobody bother to Search any more? There are four different ways that hashed files should be deleted, depending on how they were created and whether or not a VOC entry has subsequently been created.

Kamashil's suggestion will only work if your Sequential File stage that reads the file converts missing values to null. This is, of course, the default setting. If, however, you represent null differently, then you need specifically to handle the missing value differently, perhaps with a test agains...

Create a second output from the CFF stage and mark it as Reject, then change the Reject Mode so that the rejected record is send down this new link. You can deal with it however you like there.

1. No, you can use an Execute Command activity.

2. You could most easily solve this with a Routine activity. Attach to the job and get its status. Then detach.

Invoke Help from Designer or Manager and read about the options for DSGetJobInfo(). Or read about Monitor in the manual for Director client.