DSXchange

Let's start with you confirming the PICTURE clause of your Packed Decimal fields.

Is the job running on more than 1 node?

sriec12 wrote:1) Regarding Lookup Stage its not static value. Its a weekly load, I need to load the as of date for every week.

So as I said, static over the course of the run. Sure that's "fine" as it is cached into and read from memory but why not simply pass that in as a job parameter?

Using both clear and delete doesn't make sense, use one or the other. And still prefer the former. Hashed files will always be created / recreated if they don't exist regardless of setting.

Yes, I think anyone that's done heavy Server work has seen this before. I have and I know there are posts here about it as well. I forget the internal type number that is where each record of a file but it's crazy slow and mind-blowing the first time you see it. I'm not aware of any known explicit c...

"There is no bad data, only misunderstood data."

I'm sure Ray will be along to have 'the discussion' before too long.

jerome_rajan wrote:no instances are getting created when I run the job with an invocation id.

When you run it how exactly, from where?

The data would still need to be sorted for the Transformer logic to work correctly.

What role is the lookup playing in all this? I'm guessing it is providing some kind of static data for the run but you didn't clarify. And the real test would be a full load, have you done that yet?

Did we really need a new post on this? You found a nine year old post from someone who hasn't posted here in five years and thought it would be good to jump on it?

That could just be a stage variable that you increment via if-then-else when you detect a Header record. And best to run the job on a single node.

What Ernie said.

The option would work for sure but here the requirement is to send out only 1 email notification and that would have the failed job names. If I include the job status in email option that would contain too much information and the users are not really interested for it. Out of curiousity, have you ...

Ah... passing by reference sounds like the answer to both of the size concerns. If it works out.

So... not going to try the 'status' option I posted?

My first question would be - if you switch to using the IP address does the problem go away?