DSXchange

leathermana wrote:My DataStage resource folks here keep telling me NOT to use CFF and to use Sequential File.

Resist stupid requirements.

Would you accede to a request to tighten a nut using a hammer? It's simply a case of using the right tool for the job.

Learn about the rtype option that goes with these conversion functions to specify how you want the value to be rounded.

Keep working through the Planning, Installation and Configuration Guide There will be more to do than Engine Credentials. On one of the machines where you've installed the client software you should have a desktop shortcut to the jumpstation, from which you can log in to the web console for Informat...

You don't need sequential mode; just make sure that your data are partitioned on your first sorting/grouping key. The rest is managed with a Sort stage (generating a Key Change column) and a Transformer stage (using stage variables). You not only have to detect the change, you also have to detect wh...

Welcome aboard. Your system is installed but not configured.

Have you configured your Engine Credentials using web console for Information Server?

First off, highest and second highest based on what? For example, if it's column a and column b, then your expected output is incorrect. Second, why does your expected output not include six rows (highest and second highest from each of three groups)? Perhaps you need to give more thought to exactly...

Did you "test" it with a string that contained an invalid timestamp?

For example 2013-13-13 13:13:13

or even 2013-02-27T03:13:14 when your default timestamp format string does not include the "T"?

As noted, the Copy stage that does nothing is optimized out when the score for the job is composed. The Force property mandates that the copy operator be included.

It's not correct. You need to check validity BEFORE attempting to convert.

Is this an interview question? You're the third to have asked it in the last couple of weeks.

Why not just add Classification overrides to your xxNAME rule set? Class these words as "O" (organizational name suffix word).

Welcome aboard. Unless you force it to be compiled in, a Copy stage with one output is likely to be optimized out of the final design. This explains why its output link count is zero - it's simply not actually there! You can see this by including $APT_DUMP_SCORE environment variable as a job paramet...

If an after-job subroutine returns a non-zero value through its ErrorCode argument the job aborts. This is documented behaviour. Since you're using a supplied subroutine, you might like to inspect its code to determine whether it does precisely what you require. If not, clone it, then modify and use...

Don't know. Do you (have one)?

You might check the installation log to determine whether one was created.

Typically a service account called XMETA is set up.

It is not permissible what you are trying to do. DataStage does not include the ability to use one environment variable with the value of another. You might be able to accomplish it within a sequence, but you'd have to read the values of $LogDir_SYSB and $TempDir_SYSB into, for example, activity var...

You're wrong. The function you require is IsValid(). BEFORE you attempt any data type conversion.