DSXchange

The Modify stage uses a different set of functions to the Transformer stage. FIELD is available in a transformer but it is not available in a Modify stage. As I said in my previous post there are very few string manipulation functions in a Modify stage unless you are converting to or from string typ...

I do agree with you about the lack of information on PeopleSoft EPM DataStage version options. At the time it came out most PeopleSoft sales staff didn't know much about DataStage, most Ascential sales staff didn't know much about the PeopleSoft version, or new about server jobs but didn't know abou...

Probably be more effective to get two good parallel programmers and only convert those server jobs that need to be converted. 80% of the jobs may actually run slower if converted from server to parallel jobs, or have improment gains that are negligable. Server jobs are perfectly happy to run alongsi...

As a test go into an Oracle Enterprise stage and replace all job parameters with parameter values. I do this any time I have a connectivity problem, often I am using the wrong job parameter or have the wrong job parameter value or have entered the job parameter name incorrectly. By typing the values...

I don't think this can be done with the Modify stage. The Modify stage is aimed towards type conversions and has very little in the way of string manipulation. The only string to string conversion functions I know are substring and string_trim.

In a transformer following your lookup stage do the derivation. Your failed lookups will be passed through and the Cusip_id field for these will be NULL. Do a NullToValue derivation on the Cusip_id to make sure it is populated. In a server job you can do a lookup and derivation in one stage, in para...

Why upgrade your SuperNintendo to a Nintendo 64 when there is a Gamecube available? Sorry ... wrong forum. Why upgrade to version 5.x when 7.x is available? Server jobs in 5.x are the same as those in 7.x, except they are faster and more reliable due to enhancements and defect fixes. The DataStage e...

You should get better results if you can split your node resource and scratch disks onto different disk drives as this should ease I/O bottlenecks.

If you could get your hands on the unofficial inhouse DataStage Migrator then it would take just a little bit more wheedling to also get the Server job to Parallel job Migrator! By the time you've done that double migration I wonder what quality jobs you have left...

It's also got an extensive FAQ:
How do I remove duplicate rows from a data source?

It depends on what resources you are "borrowing" from those other machines. Assuming your DataStage server gets installed on the OS machine do you anticipate this machine has the CPUs and RAM required or will you be borrowing CPU and RAM from the cluster? Or are you only using them for disk space? W...

See the attached press release from a couple years ago, Informatica World 2004 makes European debut: m Since then the next two Informatica Worlds have been in the US. I think they should be running a major conference in Europe, Asia Pacific is more difficult since the distances between the cities an...

The parallel sequential file stage has an optional Option called "File Name Column", it is a varchar column that outputs the name of the file that the record is sourced from. Don't know if it works for file patterns but let us know how it goes.

You shouldn't have to manually split the table into 10-12 datasets and then funnel them together again. This is partitioning and collecting and it is part of normal parallel job functionality. If you want to split your data across 10-12 partitions then define 10-12 nodes in your config file. You can...

Hi, One way is to handle the messages. Collect all the error messge related to oracle and promote it to Fatal. regards kumar I've used this successfully to elevate parallel DB2 errors from information to warning messages. It works if the warning messages use the same message ID, but if your Oracle ...