DSXchange

ray.wurlod

Where and how are these data stored?

Most sites don't migrate data from development to test environment at all. Instead, the test data are a sample from the production environment.

ray.wurlod

I still can't believe that this won't work. It works for me.

Code: Select all

"Segment Value is " : DQuote(Market) : " and processed data will not be reported."

(Actually I use Quote() rather that DQuote(), but it should make no difference.)

ray.wurlod

CATEGORY and JOBTYPE are designated column names in DS_JOBS; why not use them? For example:

Code: Select all

SELECT COUNT(NAME) FROM DS_JOBS WHERE CATEGORY = '<<Category>>';

SELECT COUNT(*) FROM DS_JOBS WHERE JOBTYPE = 3;

ray.wurlod

Last time I checked you could install the Windows server off the Windows CD that you get to install the clients even if you have a UNIX server. You will, however, require a separate authorization for the Windows server; the platform type is one of the items of information encoded into the authorizat...

ray.wurlod

It is possible that your server has not installed the map for Korean characters to communicate with the client software. This may be MS949, or MS949-EXTRA if you need the 1992 extensions. Consult the DataStage NLS manual for how to get maps installed/loaded. If you can connect your Administrator cli...

ray.wurlod

Because QualityStage uses a pattern matching technique, it does not really require the heuristic you postulated. It can, through pre-processor rule sets, detect misplaced data, including column overlapping, via pattern recognition techniques. These can be refined over time, and rules changed or over...

ray.wurlod

Are these adjacent warnings? I would imagine that they are. The third simply informs you that it's giving up. The second informs you the name of the function that failed, presumably because no more buffer space could be allocated to the output file unit. In what mode are you running this job? Have y...

ray.wurlod

Welcome aboard. Have you deployed the job in QS? Can you please post details of what you have in the Match stage?

ray.wurlod

It has actually "buried" ALL the columns from the input, as per the documentation.

You can write that raw string to a file, or you can re-parse it with a Column Import stage - perhaps declaring all columns to be VarChar.

ray.wurlod

How about adding the closing right parenthesis on your expression?

Code: Select all

Oconv(@DATE,"DYMD[4,2,2]":@VM:"MCN")

ray.wurlod

Well, someone out there has version 8.0. If "they" were going to change the way the GUI works, version 8.0 is the most likely candidate. Anyone (who has version 8.0, of course) want to test it?

ray.wurlod

The Sequential File stage itself can have a reject link that handles any row that does not match the metadata, irrespective of the column in which the mismatch occurs.

ray.wurlod

Maybe some kind soul just added APT_AUTO_TRANSPORT_BLOCK_SIZE in to the OP's project via the Administrator client.

ray.wurlod

<Thinks>
What happens if you specify it as being in an account, edit the Selection tab, then switch it to a pathed hashed file?
</Thinks>

<Thinks>
Further research is clearly required.
</Thinks>

ray.wurlod

it is working.......but it is repeating some numbers......how i can avoid this? You specified random. Random numbers can repeat. You did not specify unique random numbers. This is not possible in the generator. You will need a Remove Duplicates or Sort stage (with "Unique" checked) downstream.

Search found 53125 matches