DSXchange

Okay, I see that is indeed what this is all about. Probably need to wait for people with that specific knowledge to reply, that or get help from your official support provider but in the meantime I doubt that simply including the token in your call to DSSendMail will get you what you want. I would i...

Sorry... wasn't quite sure what you were trying to do and did not come back to this until now. I for one am not familiar with "%fullreport%" and don't have access to check. Are you trying to replicate the Job Status in email checkbox option from the Notification Activity stage in a custom ...

contactshashi wrote:Do you mind to share your email id

You can use the "Send e-mail" link in their signature/footer area to send them an email. Then they can decide if they want to reply and "expose" their email address to you. Don't see a real need to have it listed in the post forever...

Done.

This sounds like a QualityStage question... yes?

May need more information but you would use the CHAR() function to represent an unprintable character. So for the carriage return you would use CHAR(10) wherever you needed to "add" it.

I'm suspecting the caching you are thinking of only applies to hashed files used as a lookup, not as a source or target. Now, technically, the write to a hashed file can be cached. You still have to wait for the cache to flush before the job ends and there's no read caching that I recall outside of ...

Sorry but... can we start with what "the cache capabilities of the hashed file" means in this context? Don't get me wrong, I cut my teeth on and loves me some hashed files but curious what - as a source and target - you think it gets you over a PX dataset in your PX job?

I'm assuming you're not strictly addressing the "max value" aspect of this for the target but are advocating the landing of the source data before starting the load so you have a static source in the event of an abend. If so, I agree 100% with that... for whatever that is worth.

Did you get a resolution to this? Either way should be possible but I would suggest a separate job/task do the "get max" part and then pass it to the job as a Job Parameter. And I assume this methodology would only be valid if this process is loading the table in isolation, meaning no othe...

Ah, yes - thanks Mike. Had a bit of a <squirrel!> moment and didn't add that in as intended after my search. :D

That is a vertical pivot (rows to columns) but with... a twist. Rather than use a pivot stage, you'll need to do it yourself in a transformer. Have you ever worked with stage variables to do "group change detection"? In your example, that would let you know when you hit a new ID value. Eas...

PaulVL wrote:The install path should be different of course.

I'm wondering if their install paths were, in fact, different.

If it can load the same data from source A but not source B or C, it still smells like a connector issue to me. Simple enough to check with support to find out.

To me it sounds like a connector bug, especially if you are still on an 8.x release. In your shoes I would involve your official support provider to help determine what's going on, which which is which.