DSXchange

The lookup is performed, unconditionally (you get no choice on this) in a Transformer stage with a reference input. The same Transformer stage can be used to perform the derivation of your output column. However, your logic is not clear. Use the Expression Editor to build your expression, noting tha...

Search was case sensitive - everyone had typed "menu bar" but you searched for "Menu Bar"?

Local Windows is a good run profile where both client and server are on the same machine. QualityStage must find the source file in the Data folder, and will write the results into the same folder. The source file name must have no more than eight characters, and no suffix - has Notepad put a ".txt"...

If you think it is, then yes. And maybe start your own best practices book. Tip: use your Favorites folder here.

1. If you mean a sparse lookup, no - that's only supported for DB2 and Oracle. If you mean a Sequential File stage feeding a reference link, then yes. The contents of the sequential file are loaded into the virtual Data Set associated with the link. However, if it is too large, this will fail. 2. Ye...

That's OK, you're new. But, like I said, it can often get you an answer faster. Another thing we like to have happen is that, if the problem has been resolved, then the original poster marks the thread as resolved. There is a "button" near the top of the window for this purpose.

Welcome aboard. You would have had your answer faster by searching the forum as, curiously enough, you are not the first to encounter this. The stage upstream of your Sequential File stage has its Preserve Partitioning flag set to "preserve" but the Sequential File stage, since it is operating in se...

Finally I understand. You want to generate rows when there are no source rows, so that you have an unbroken sequence of integers in the line column. Probably the easiest way is to generate a sequence of integers (Row Generator stage) in a separate stream and outer join that to your existing stream. ...

No you don't. You want to design a job sequence that does this.

This is because a job can not legally change its own parameter values.

Fixed width is better in terms of being able to parse the contents, because substring is a far faster operation than scanning delimiters. Bulk loaders perform noticeably faster in a fixed-width regime, particularly where there are no VarChar fields in the table. On the other hand, delimited can mean...

The vendor used to have a training class called DataStage Best Practices but I fear it is no longer extant. It was for server edition only (enterprise edition not having been released at the time).

Apart from that, and anything developed in-house at various sites, the answer is no.

Have you moved your data file GS000000 into the Data folder (C:\Projects\NewGS\Data) for your project? Have you created a run profile in your QualityStage Designer?

Best practice is, indeed, to stage your data at least once between extraction and loading. It is not necessary to do so, merely wise. It means, among other things, that you only have to perform extraction once (important for "point in time" extraction); that you can have separate time windows in whi...

Best solution is to demand that the author of the stored procedure fix it so that it returns zero rows if there are zero rows selected.