DSXchange

Remember that a PC benchmark is different than how "we' measure performance. If we wrote one single-threaded process and ran two copies simultaneously, that's different than a WinStone or whatever benchmarks Photoshoppers and gamerz use.

Sequential stages with Unix file specified now needs to be DOS as well.

Here's the trick. Write a function to take a date YYYY-MM-DD, add one to the month and allow for going over 12, then use the ICONV function to make the date the internal integer value. Subtract one from that value and then use OCONV to reformat the date. You will now have the last day of the month f...

Yes, a dual core means the chip was shrunk to 1/2 the size, so they "glued" two together (internally of course). So you have P4, P4HT, and P4D. Given a choice, wouldn't you rather than 2 in the same space as 1? The only issue is Windoze thinks a P4HT is 2 chips, which sucks, it's not.

make your own file to test.

If you haven't noticed, non-Premium Member questions are being left open for a little while before we jump on it. I've been trying to "promote" other folks by letting them try first, if I don't need to add to it or correct it - I don't. But, if a Premium Member posts something, I'll jump right away,...

Dual core means 2 chips on one set of pins. It's truly 2 cpus. Hyper-threading is an Intel trick to simulate 2 chips, but it's really 2 pipelines on one chip. Both show up to Windoze as 2 chips. Given a choice, dual core is the one to want. Hyper-thread is about 1.2X the power (in ideal situations),...

Sounds like out of disk space, which will give you corrupted job logs.

Looks like a corrupted job log. Consider purging the job log, if that doesn't work, try exporting the job and re-importing it to recreate all supporting files.

Here's something to think about: The constant answering of all "small issues" questions by the Premium Posters has actually harmed this site. There are 100's of members who could have answered, but don't, because they know that the top posters will swarm on the question and answer it. This means tha...

Premium Membership only buys you the "privilege" of viewing extended answers from 6 individuals. Other experts have no restriction on posting and sharing answers. All complaints center around 6 individuals' answers. The future of the site will include video and audio. Who's paying for that developme...

Great meena, you gave him a solution utilizing a table "calendar_table", which is just like a Time dimension....

hariprasad wrote:My Database is Oracle.

kcbland wrote:DATABASE? ...

Fantastic, but it's not your question to answer. A person demanding a database specific query solution should have the courtesy to tell us the database they are using.

Else I'll be tempted to answer with SQL for the most arcane RDBMS I can think up.

DataStage does not have anything like this, it doesn't read or write these. The Sequential stage is a traditional sequential textfile reader/writer.

A quick google found this for your reading pleasure:
http://www.theteacher99.btinternet.co.u ... p5_7_1.htm

First: DataStage does not run GUI programs, it moves data around. If you want to see it run a OS command, you can start with a simple test. Just try "echo 'hello world". You should be able to read the job log and see the message. After that, it's up to you to make sure that directory paths are accur...