DSXchange

What do you mean by "date format"? Give an example of your desired output.

Also, since you don't have premium membership yet, you can't read all of my previous answer.

Can you explain more completely what SEF is, and how it extracts data from UniData? Are you using a state file for the surrogate key storage? What syntax are you using for the function that delivers the next surrogate key value in the Transformer stage?

1. No.
2. No.

Did you search for "GMT" and "daylight saving"?

Have you looked at the time-handling transforms and routines in the SDK?

First, I would rewrite it so it doesn't abort. Abort is anathema to unattended running.

I have no idea about whether your wait time is adequate, because you have not provided enough information about the expected arrival mechanism of file X.

There are reasons, but they should be rare. Allow me to quote from The Data Warehouse Lifecycle Toolkit by Kimball et al: Generally snowflaking is not recommended in a data warehouse environment, Snowflaking almost always makes the user presentation more complex and more intricate. Database designer...

Transformer stage functions are intolerant of NULL. You must handle NULL explicitly. Of course you can generate a default value, say "", instead of using the SetNull() function.

Can you prefix the result with a single quote character, so that Excel treats the value as literal text?

In version 8 exports are done from the Designer, since there is no longer any Manager client. What Craig asserts is true for exports done from Designer.

Add it to the project in the Adminstrator client. Then, perhaps when you use it as a job parameter, set up the default value as $ENV (which means "pick up the value from the underlying UNIX environment).

In the log early in the job run is an entry listing environment variable values. What is the value of the TZ environment variable?

1. DTM is VarChar, so you can use LIKE operator. WHERE DTM LIKE '2009-02-11%' 2. It's the MAX(DTM) in your query that is eliminating some of the User2 modifications. Lose the MAX() function. 3. You don't need IN if the sub-query is SELECT MAX(DTM)... because the sub-query can only ever return one ro...

Specify precisely what you want to do.
Read the file one line at a time, with the whole line as a single VarChar (or Char) field.
Parse into fields in the Transformer stage.

Another approach would be to use the Complex Flat File stage rather than the Sequential File stage.

When your job is compiled the stages you use are converted into Orchstrate operators, and the functions that you use to convert data are converted to those used by the modify operator (which is also used for the Modify stage). As a general rule the "To" function names are for the Transform...

Export/import is the approved technique.