DSXchange

Actually, all you should "lose" is a little time. No abort or permance issue other than what you've already got with a large hashed file read directly from disk. Checking that option means it will try to cache it into memory and, when it can't, it will note that in the log. So if you know it will ne...

Ok... what version of DataStage? What Oracle client version?

You can't "develop a parallel job in Server edition". If all you have is the Server edition, then all you can generate are Server jobs. If you have the Enterprise edition, then you can create either. And the same Designer tool is used for both.

ysrini9 wrote:How to convert julian Date format to Oracle Date format

The specific answer depends on whether this is in fact a Julian date or an Ordinal date. That will drive the flavor of IConv you will use to convert the date to internal format.

After that, my advise for the output format applies.

That's a real Julian date. Typically people mean an Ordinal date when they say Julian - the year plus the day number of that year. That being said - there's no such thing as "Oracle date format". Oracle dates are stored in an internal representation and you can load and extract them from Oracle in ...

Yah, that helped alot. And meena meant edit your first post (which you can do) not post it again. If someone wants to see something more 'formatted' you'll need to paste it into a tool like XMLSpy and make it 'Pretty'. Silly question, but why not use a Server job and the 'normal' combination of Fol...

You may want to consider doing the 'value exchange' separately as a first step rather than on the fly in this job. Doing the substitutions would be straight-forward in your job, but the 'random lookup' might be an issue as it seems like you'd need to do each one X times until you hit one that "wasn'...

Ok, it's dead Jim. Now, where in the heck can I find its new home on developerWorks? Somewhere in the Websphere forum arena?

There's only one version currently of DataStage that allows PX jobs to run on Windows - 7.5x2.

Confusing. Why would you not want to reject the second lookup record? It sure seems to meet your reject requirements of "match found and date not lies between start_date and end_date".

vmcburney wrote:The problem is that it performs all those transforms on all rows before the constraints are applied.

Well, that's just... silly. The Server variant is smart enough not to do that, I would have though the Parallel version would be even more smarter!

You shouldn't have to unprotect the project to do the import - as long as you are using your 'administration' user (typically dsadm) it should import just fine. You might want to try one job that way. Or, as you've found, you can unprotect the project. But that's kind of like dropping the shields ar...

As noted - we'd need to see the script.

You mean other than this - "User does not have WRITE permissions to current directory"?

Your newly created project directory is not writable by the importing user, it would seem.

It's on your client CDROM, under 'Support Utilities' from what I recall. It allows you to support two Server versions by switching between two Client versions on your PC. NOTE - only one Client version can be active at any given time and you must have installed the two Clients to two completely sepa...