DSXchange

Please be careful with your spelling, grammar and punctuation. It would be vital that your presentation is professional whether you were creating a functional document or a technical document. Their meanings may vary, depending on who you ask. To my mind a functional document is one that describes w...

You may find it preferable to read using a Complex Flat File stage, which can deal with level numbers. Or, in the extended column properties (accessed via Edit Row in the Columns grid) the level number can be made available. However, the errors here are from the Transformer stage, and it seems to be...

It's not that easy, as reading my entire post will show. To be able to do that, sign up for a premium membership. It's not expensive - less than 30c per day - and well worth it. Premium membership is one of the ways in which the hosting and bandwidth costs of DSXchange are defrayed. By taking up a p...

The existence and location of the project is recorded in at least three tables, two in the DataStage engine tier and one in the Repository tier. UV.ACCOUNT is one of the ones in the engine tier, and you can use a regular DELETE statement (in DataStage SQL) to remove the entry from this. UV_SCHEMA is...

Get an ODBC driver for Excel and use an ODBC Enterprise stage.

Two jobs. One to do the calculations and store them into a hashed file, the other to merge the streams of results.

DS_Perf_Recalc is the name of a job.

Premium membership will allow you to read the entire answer. Premium membership is one of the ways that the hosting and bandwidth costs of DSXchange are defrayed. I do not propose to create any precedent for undermining that mechanism. Premium membership is not expensive, at less than 30c (Rs12) per...

From which omission you can determine that Windows 7 is not (yet) a supported operating system for DataStage.

Rumour has it that Windows 7 will be supported, at least for clients, in the next version.

Search. This exact question has been answered within the last week.

What if you define no columns on the output side of the Transformer stage?

Yes, that's why the filter operator is <= downstream of the Join stage. Upon re-examination you not use an Aggregator to count - you would use a Transformer to generate a counter per group. Which is close to the original suggestions.

All of a sudden? What changed?

Is there a new client version involved here?

That's probably true given the structural damage to DS_JOBOBJECTS, which would take a substantial amount of an expert's time to repair. It may be able to be repaired using fixtool, it may not.

Create an extra output link from the Transformer stage and send them to, say, a sequential file. They can also be seen if you are running the job in the interactive debugger.