DSXchange

Had to post before 12 noon local - them's the rules!

Probably broke the embargo, but who cares?

From AFP * ARMONK, N.Y. - April 1st, 2008 IBM (NYSE: IBM) and Informatica (NYSE: INFA) today announced that the two companies had entered into a definitive agreement for IBM to acquire the equity of Informatica Corporation, a publicly-held company based in Redwood City, California, in an all-cash tr...

attu wrote:

ray.wurlod wrote:Don't forget that the DS.CHECKER utility cleans up orphans left over from incompletely-deleted jobs. ...

So if someone needs to delete his job, whats the prefered way of doing that and preventing those orphans to be created?

Use the GUI. Ideally at a quiet time.

Your Trim() function is wasted while the data type is CHAR because DataStage will pad a char field to the appropriate length. You need the data type to be VARCHAR for the effect of the Trim() function to persist.

Don't forget that the DS.CHECKER utility cleans up orphans left over from incompletely-deleted jobs.

Download ETLStats from Kim Duke's website

Trim() either in DataStage or in the extraction SQL.

egsalayon wrote:im using designer to connect to datastage which previously i can do.

What has changed? "Nothing" is not the correct answer.

Or perhaps mention when the interview is.

When's the interview?

If you call it from a job sequence or a before/after subroutine you use a server routine, not a parallel routine. Do you really want to set the environment variable for every row processed?

One's for Oracle 8, the other is for Oracle 9 (and can talk to Oracle 10).

Not enough information for a cogent answer. This is easily done with DataStage. But why re-invent the wheel? Download ETLStats from Kim Duke's website.

If you are getting these dates from a database, simply add the word DISTINCT to the derivation of the first column.

Make sure you have write permission to /apps/opt/IBM/InformationServer/Server/Scratch