DSXchange

OK, just seemed that way to me based on zulfi123786 being the only one mentioning anything that seemed 'user based' where things worked under one user but didn't under another. Arnd was the one responding to datisaq's query on the how of the umask setting. I agree it's a best practice and all, I jus...

Some of it is cache delay but your job might not be as dead as you think. Try a "ps -ef |grep phantom |grep -v grep" from your command line and kill (NOT a kill -9 but just kill) any left-over processes you can find for it.

Ray was responding to zulfi123786 rather than you, I believe. Your problem is one of syntax I would wager. You need to provide full credentials from the command line, meaning userid and password. For 8.x they added in the need for the domain as well, so add all three to the command line and let us k...

Out of curiousity, for those of you that dabble in both worlds, what's the Informatica equivalent of DSXchange? Looking for the best peer-to-peer support forum for that other tool.

Thanks.

datisaq wrote:I have ran the other jobs also but still the same error.

And this means what exactly? You cannot run any job as all attempts get this error or everything else runs fine and you get this error only for this particular job?

chulett wrote:You would need the PX version of EReplace that's posted here somewhere.

That or perhaps Ray's "Left:Right solution".

What "OLD repository" would we be talking about here?

This question has already been re-posted in the proper forum, btw.

Yes, please explain why you think you "need" to do this using UV commands.

In the posted examples, true, but I'd be worried about that pattern holding up for all of the real data they need to process.

Sorry, I had an immediate need to go for a job interview, so that took precedence. :? And people can't decide on a solution for you, it needs to be something your company can support. For example, how will you know that "02/17/2010" is a holiday? Someone can lay out a solution that leverag...

I guess I can be Ray if that helps.

Yes, you are absolutely correct that "long filenames" in DOS require quoting if they contain spaces, with "Program Files" typically being the first culprit people stumble across this with. That or you need to sub in the original 8.3 format name that is still actually there and hi...

But won't that do a character by character replacement, meaning sending it "GH" won't remove the string "GH" but rather all the "G"s and all the "H"s instead?

You would need the PX version of EReplace that's posted here somewhere, I would think.

Hopefully this is all an academic excercise to assertain whey it is behaving differently in different environments. As a Best Practice you should stick with using a Timestamp for Oracle DATE fields and letting the stages generate the SQL with the appropriate TO_CHAR() and TO_DATE() functions. That t...