DSXchange

ray.wurlod

YYYY-MM-DD HH:MM:SS is THE most standard format for a timestamp, it is defined under ISO 8601.

Your allegedly "more standard" format simply isn't.

Run your result through a sed or awk script to remove all the non-numeric characters (or even tr -d).

ray.wurlod

Only if you post the question in the correct forum (General).

This forum is for questions pertinent to Master Data Management. Your question is not.

ray.wurlod

Code: Select all

SELECT * FROM RT_LOG5276 WHERE @ID = 141;

The control records are those that begin with //.

Code: Select all

LIST.ITEM RT_LOG5276 WITH @ID LIKE "//..."

ray.wurlod

Removing the dots is the solution. Tags with dots do not count as "well-formed XML" and DataStage expects well-formed XML.

ray.wurlod

You are correct about a partially transferred file triggering the Wait For File stage. The usual solution is to get two files, the second a small or even empty file, and trigger the Wait For File stage from the second file, which will not begin to arrive until the first file is complete.

ray.wurlod

Exporting a job executable executes only the job executable (not its design) so that, in the project into which it is imported, the job can not be re-designed, it can only be run. Exporting DataStage components allows you to select what to export, which can include both designs and executables (in d...

ray.wurlod

Another work around Im thinking is to define all the variables to $PROJDEF in parameter set. But thing is if anyone wants to change any variable on run they have to open Administrator and make change. That is not true. When a run request is issued you can override any individual parameter value, in...

ray.wurlod

Add a line terminator to the last line in the file.

DataStage is looking for it.

ray.wurlod

... but the job type is marked as Server.

Do you have MKS Toolkit or any similar UNIX emulator?

DOS does not natively have an equivalent of wc or tr or head or awk commands.

ray.wurlod

For one dimension table:

Code: Select all

           DimTable
               |
               |
               V
     ----> SCDStage ----> FactTable
               |
               | 
               V
           DimTable

ray.wurlod

I too am currently working at a server-only site, and parallelism is possible. Even without it, some jobs are processing tens of millions of rows quite efficiently. The difference is in how the job types are executed. Parallel jobs are executed in a parallel execution environment, and so are suited ...

ray.wurlod

U has not posted on this thread.

The second person personal pronoun in English is spelled "you".

ray.wurlod

So verify whether Event 141 exists or does not exist. If it does not exist, verify that the control records are correct.

ray.wurlod

Using the Data Set Management utility determine how many segments (data files) exist on each partition.

I'd be concerned about the // in the pathname also. But this is unrelated to any message about segments.

ray.wurlod

Version 8 yes, version 7 no.

Search found 53125 matches