DSXchange

A preceding Modify stage can be used to rename columns.

I am a totally independent consultant, and have never been an employee of Ascential. I have no greater influence with the vendor than you do. You can post an enhancement request here at DSXchange, or on Ascential Developer Net or through your support provider. The "Hawk" release is far too advanced ...

A persistent DataSet comprises the control file and one or more data files. You can cat the control file to determine the location of the data files. Then you can process this list using find (with -ls option) to determine which ones are old enough. Then use appropriate commands to move or remove al...

3 lakhs of records is not "big" for a hashed file. Go for it. Only load the columns that you actually need, so that the run goes as fast as possible (without carrying redundant data, which you are - necessarily - doing in the ODBC table). Pre-allocate the space (use MINIMUM.MODULUS for a dynamic has...

Congratulations on solving it. :D

Error codes like ORA-01722 are generated by Oracle. You can obtain more information about them using the oerr command on the DataStage server machine. For example:

There is no parallel equivalent to the Folder stage (and, if there were, it would necessarily run sequentially). Similarly, there is no parallel equivalent to the XML Input, XML Output and XML Transformer stages. You could construct your componentry in a server Shared Container, and incorporate that...

That's 27 conductor processes, 108 section leader processes and 216 player processes (assuming no combination), a total of 351 processes. Do you have at least 175 CPUs on your system? It is recommended (as a rule of thumb) not to use more than two processes per CPU in PX jobs. Can you find an approa...

SAP R/3 Load stage. It's part of the (separately purchased) SAP R/3 PACK.

With Stored Procedures you can generate your own, non-standard, error and warning codes. This tab allows you to specify how DataStage should react when one is encountered. The choices are, essentially, "fail" (abort) or "warn" (log warning message). Although I haven't tried it, it may also be possib...

Could also be a firewall blocking port number 31538.

A (persistent) Data Set has rows on every processing node. It can therefore be processed in parallel. Data in a Data Set are in internal format (for example, an int32 occupies four bytes). A File Set is like a Data Set, except that the data are stored in external (human-readable) format, so require ...

All this is likely to change substantially in the next release ("Hawk"), which is only a few months away. Try to wean yourselves off hacking the Repository where possible.

Please don't tag your posts here as urgent . This is an all-volunteer operation; folks post as and when they can. If you want urgent responses, sign up for premium support from your support provider, with a KPI of (say) response within an hour. You will then learn something of the true cost of "urg...

hi, pls send anwer for the follwing questions 1 .how to refresh the hased files? 2. which will execute first routine or transform? 3.what is the difference between routine and transform? thanks and regards raj Can you be a little more specific with the questions? For example, in what context are yo...

Don't forget Kim's word of the day "serks". As in "newbie question serks".