DSXchange

Not sure I'd call them "performance boosters"... more like potential problem children. They're basically a mechanism to pass information from one process to another without really 'landing' it somewhere, much like a message queue. One process puts something into the pipe (the writer) and t...

Hmmm... you can't just compile away the problem with the job. You need to go through the logs and see if you can get a clue as to the nature of the failure. Have you had any luck with that yet?

Detail your job design, please.

No clue.

Use an Execute Command stage in a Sequence job rather than a subroutine.

If you know how to take the last field, to get everything up to but not including the last field use "1, dcount-1" where you have "dcount" right now. For example: Last field: Field(YourField, " ", DCount(Yourfield," ")) All other fields: Field(YourField, "...

Also note that if you used the FTP stage to bring over a compressed file to the ETL server, you may have destroyed it in the process. The stage is metadata driven and meant to process on a row-by-row basis which isn't possible with a compressed archive.

First you need to know how the files are encrypted. Knowing that will give you the ability to know how to decrypt them and how to manage that in DataStage or at least under its control.

123gopal wrote:check RCP at job level and admin level

Curious what that has to do with the subject being discussed.

You will need to explain this in more detail before anyone can do anything other than guess what needs to happen here. I'd also be curious what you've tried so far or if you just came here and posted your work assignment. :? As a guess, this looks like some kind of lookup. Is "IMONO" a tab...

True for other job types as well. And yes "as is" - it will just become a string, hash signs and all.

So... this is resolved?

Unfortunately, only the site owner can activate your membership. If you've sent emails to the Membership Director about the only other thing you can do is contact the Editor as well.

Sometimes they check this forum as well.

You must have better testers than we do.

Again... details are missing. What exactly are you doing in the transformer to get the "month"? What are you grouping on in the Aggregator? I'd first verify that the aggregation itself is doing the right thing before you start worrying too much about the join.