DSXchange

Any chance you could use a Server job for this? That would make it trivial. Otherwise you need sorted input & group change detection via stage variables to perform this feet, that and probably a known 'end of data' record added to the stream to pop out the last group.

a) I'm afraid I don't really understand your issue. If you want help tracking down a job failure you'd need to post the actual failure message(s) and detail the job design. b) You can't delete records from a hashed file, at least not via conventional means. What makes you think you need to do this? ...

No mention of their database being Oracle, at least not yet.

Try:

SELECT MAX(COL1) as COL1 FROM TABLE

And see if that helps. Make sure the "as" column alias matches the name you've given the column in the stage.

You can use the ODBC wire drivers for Oracle and not need a client, or install a client and then use the ODBC non-wire drivers or the native Oracle stages.

I don't have the docs handy but isn't that stage mentioned somewhere in them? Have you done a PDF search for that term across all files in the directory?

Typically, the metadata mismatch between your data records and your header row will cause the header row to automatically be rejected by the stage. If you are seeing them, then you'll need to filter them from the other records in a transformer or filter stage by checking for your column name's value...

Yes, you have two ways to do that with slight differences in the outcome between them. There should be a 'Load' button on the Columns tab that allows you to point to a save table definition and load it into the stage. The other mechanism is to drag the table metadata from the repository browser and ...

Which doesn't really answer the question, especially for people without Oracle experience. Specifically, how do you define a month? As asked, what does that Oracle function give you when you subtract 1 month from March 30th?

Yes, both Server and Parallel jobs can and there's an entire forum dedicated to that topic.

Exactly, which a quick check of the documentation would easily reveal.

Soundex is Soundex and really should behave identically across platforms. Have you found that not to be the case?

Ah... gotcha.

Can you share with us how they had you "change the configuration file"? I was under the impression that they were generally not editable.

Show us the syntax you are using in the routine.