DSXchange

Yes, but why not find it yourself, perhaps via an Internet search? There are volumes and volumes written on the topic, and some differing opinions about what's "best". Or are you specifically asking about how to manage surrogate keys in DataStage server jobs? That usually involves using on...

Maybe the character is not a space character, but "white space" (a tab, perhaps). Did you try what I suggested, or was I just wasting my time?

Try extracting the column as a Long VarChar data type - perhaps with a CAST in the SQL, perhaps just setting the metadata.

These are the only two possibilities. Therefore keep using the code that you're using.

Incidentally, the semi-colons at the ends of the For statements are not required. They introduce harmless empty statements.

Can you see any job logs from this project using the Reporting tab of the Web Console for Information Server?

The PAT file is not missing and is intact. The problem is with the input text override file APPCLIB/USMNAD.ITO - or maybe that the subdirectory APPCLIB does not exist.

It would seem easier to ask how to manage the DB2 storage than to change databases. However, and provided that you have run the scripts to create an Oracle version of IADB, there's no reason not to set up a data connection to it and configure it as the analysis database.

You need client.

Please ask the IBM person how you can use Oracle Enterprise stage without Oracle client. I'm sure we'd all be interested to know.

prakashdasika wrote:The SCD stage does not exist in 7X, you can use change capture in conjunction with Insert/Update

Good catch!

You need to detect change in the pno field and only increment if a change is detected. There are lots of ways, usually involving stage variables (and maybe a Sort stage). You can find these using the Searchcapability of DSXchange.

What syntax are you using for the Field() function? Is what is being retrieved 18 characters long? Then you could extract the YMD format date using Field() functions. Field(Field(InLink.TheString, "(", 2, 1), ")", 1, 1) Store this in a stage variable. Apply an Iconv() function to...

The value with which $PROJDEF is replaced is stored in the project properties (the Administrator client environment variables area) which, ultimately, are stored in the DSParams file for the project. The value with which $ENV is replaced is not stored anywhere; it is picked up from the underlying ep...

Your understanding of the difference between Drop and Reject is correct.

Create a numeric representation of the timestamp as a string (for example 201008311541 and use that in the lookup. Can you be a bit more precise about "within a minute" implies? The granularity of your timestamp is already "minute".