DSXchange

Segmentation fault (you could Google it) is trying to access memory that you're not entitled to access. Are you really generating a new string[50] for every row processed? Surely that will eat more and more memory until you hit a boundary on your workspace. Can't you re-use the same string[50] varia...

Updatable lookup is the dimension output from the SCD stage.

Use Information Analyzer. That's what it was made for.

Sure it's tedious - but the tool absorbs most of the tedium - all you have to do is to review the results (in this case the frequency distribution of formats). You can even generate a report.

Table defintiions in the local repository are stored in a hashed file, so you need a database query to retrieve them. SELECT DSRID FMT '32L',EVAL "@RECORD<12>" FMT '32L' COL.HDG 'Column Names' FROM DS_METADATA WHERE @ID NOT LIKE '\%' DBL.SPC; From the command line you can execute this quer...

I think this can also be done in server jobs with Folder stage. It can also be achived with a Hashed File stage using Type 19 (= directory) as the hashed file type.

That's Ctrl-@, also known as Char(0), and is the default value of APT_STRING_PADCHAR. Could it be that an earlier job has processed these fields as Char data type?

Specify a larger scale value than 3.

If you remove the ustring you definitely will not be able to process Japanese characters. However, if you wish to do so, click on it - it's a drop down list in which the other option is empty. Choose that option.

TargetTable ----> HashedFile | | V SourceData -----> Transformer ------> TargetTable | | V HashedFile The two hashed file stages refer to the same hashed file. Do not use read cache or write cache. Do use lock for update. This design will work equally well in version 7 and 8. Bring as few rows and ...

Yes, and no. The Information Server installer will install WebSphere Application Server if your environment is 32-bit.

If your environment is 64-bit you will need to pre-install WebSphere Application Server 6.0.2 then upgrade it to 6.0.2.27 (a single fix pack) to handle the 64-bit environment.

Welcome aboard. Did you edit the uvodbc.config file in the DSEngine directory or the one in your project directory? (It should have been the latter.)

You have selected just these three columns in the base AND in the paired table? How many rows in each table?

In a fixed-width file format the entire field must be filled with the representation of NULL. That is, the Null Field Value property must contain the same number of characters as indicated by the Display Width property. In this case, the data type is Date, so the format string for date comes into pl...

This is a vertical pivot requirement. Ostensibly the Pivot Enterprise stage in version 8.1 can perform vertical pivots, but I don't believe that's the case. Certainly it can in version 8.5. (I don't know which version you have). If you can't use Pivot Enterprise stage, there are alternative techniqu...

That's basically it, but "load" here is being assessed before anything runs, so it's measured by operators already assigned to that node or, all else being equal, as the next after the one just used.