DSXchange

Create the following initial procedures. ADDKEY add a unique identifier to each row (can be a sequence) STORE95 put the 95 unneeded columns into a file, with the key STORE5 put the 5 needed columns into a file, with the key The STORE5 output file becomes the input file for scrubbing. Preserce the ke...

Posted on behalf of Nag, who sent a private message. hello Ray, I have a rawdata and datafiles i need to do address scrubbing on five columns out of 100 columns in the raw data. What is the procedure should i follow and should i keep the raw data in the data/projects directory as i am new to this fo...

You'll hit the Y10K problem in ISO 8601 dates before you'll need Decimal(20)!

I disagree. There may be very many topics, say after you've returned from vacation. You want to mark them all read, but there may remain one or two that you'd still like to look at.

That raises the interesting question of how well parameterized names are propagated from DataStage to the MetaStage hub.
Certainly it's not well done to doc_tool.mdb.
Would anyone else like to share examples?

Don't forget that you can set run-time parameter defaults that are different to the design-time defaults, using Director (Job > Set Defaults).

Not as much as bringing me in from Australia! However, this is a job that could be done "by remote control". If you were to create a specification of exactly what your control requirements were, a competent consultant could craft the code and ship it back to you, where you could inspect it, learn te...

You get free time during the work week ?!!

One of the many things that Quality Stage (formerly known as INTEGRITY) can do is to "bucket" data into standard fields, and to standardize particular classes of words. For example, in addresses, some of the standard fields include house number, street name, street type (for example "street", "avenu...

There's nothing I'm aware of apart from editing the generated ABAP code. Have you sought advice from Ascential via your support provider? There may be some hidden trick (though I'm not aware of one, and the fact that the SAP Extract PACK is certified by SAP probably means that there's not much that ...

This looks very much like you've discovered a problem in the job compiler in that either you've managed to create a component with a NULL identifier, or that the call to the process to update the RT_CONFIG143 file (in which run-time configuration is stored) has failed to set a value for the RecordID...

In what country are you operating, Yi Ming?

I wonder who in Ascential gets to figure out the licensing issues!

The entire statement writes the contents of the variable "Record" into a file opened onto the variable VOC.FVAR (presumably the VOC file) with a key value of "&Folder&" without releasing the update lock. For this to make sense you would need to know the contents of the variable. I would suspect it's...

Well, first (and most obvious) is the Sort stage.

As well as that, some partitioning/collecting operations will automatically perform a sort.