DSXchange

Perhaps you just mean "stage variables"?

The FTP stage doesn't support wildcards. So you'll either need to get the filename before running the job, or fall back on a scripted approach.

In other words, the short answer is "no".

That part looks fine. Try switching to using the NOTFOUND Link Variable rather than the null check and see if it works more better.

Another good place is Kim Duke's site in his Tips & Tricks section. You'll find a very nice Best Practices document for XML there, highly recommended.

Dimension --------> Hash | | Lkp on hash Source -------> Transformer --------> UpdationHash Code tags, people, code tags. Doesn't anyone preview their posts before pulling the trigger? Post your derivation code. How are you checking the hashed lookup results and branching around the Key routine cal...

Check to see if the date is valid or not, reject it if it is not.

Which part of that do you need help with?

Install it on a supported platform, use a supported compiler and configure it correctly.

Search the forums for the use of the "IsValid" function.

These typically are not DataStage "issues" per se but rather issues on the database side, in spite of what your DBA said. For example, Case (i) - define "load". Plus - how is the table structured? How many indexes does it have? Etc, etc.

Probably. What happened when you tried?

You don't need to introduce a Sort stage into your job but you do need to understand how your data is (or isn't) sorted and how that relates to the Sort settings in the Aggregator stage, especially when compared to the grouping being done.

What was your resolution?

That query doesn't really tell us what you are trying to accomplish. Please try to spell out in words what the problem is that you are trying to solve. Forget the "max case" query, just talk to us. Examples of your source data and what it would need to look like in the target are always helpful.

Of course it is "still firing". As I said, that is How It Works and nothing will change that fact. Adding the process break means the output is NOT going into your hashed file which you seemed to want to protect, they go into your flat file first and then only get written to the hashed file if that...

Welcome Aboard. "Role playing dimension"? Not really sure what that means, except perhaps where World of Warcraft players live. Where did you hear this, in what context? Ah.. silly me... Google is a better place to start than here. For example: "http://en.wikipedia.org/wiki/Dimension_(data_warehouse...