DSXchange

Why start yet-another thread on this same topic?

http://www.dsxchange.com/viewtopic.php?t=116096

Yes, Version Control easily supports multiple VC repositories / projects in your version. And it seems to me you'd definitely want to set up a separate one for this 'test' environment.

OConv with the DWA conversion code will get you day of the week spelled out. So a routine that takes a passed in date and returns the following could be used to branch in your Sequence. Something like: Oconv(IConv(YourDate,"D-YMD"), "DWA") You could then check for...

crouse wrote:wouldn't pass my interview.

Dang.

Hold on, what does your job design look like? You should use the External Source stage to replace the Sequential File stage, not use both.

Why do you have hash/pound signs in your 'xml subdirectory path'?

Google.

http://en.wikipedia.org/wiki/Floating_point

http://support.microsoft.com/kb/42980

Etc.

What Ken said. Execute a script to truncate the table via sqlplus in your routine, if you feel the need to use a routine.

Of course.

That's unnecessary complication. The first answer is more appropriate, simply check the lookup status and swap values in each derivation based on the result of that check.

And in your case, the "previous day's records" = everything in the table?

And in your case, the "previous day's records" = everything in the table?

Read it as one long varchar column, then parse out the first column (with FIELD more than likely) and take it from there based on that value.

Any chance you had space problems where DataStage is installed and corrupted your project? Perhaps a REINDEX is in order.

I posted the contents of the "What's new in Version 7.5" document in the FAQ forum. That's as close as you're going to get.

Actually, it's not impossible. For an Oracle sequence, you simply use a query of "select X.NEXTVAL from DUAL" with a single non-key column to hold the result. No key is supplied in the reference link and it returns a new key for every record through the job. I've done this and it works 'fine' althou...