DSXchange

or, find the first day of the next month and subtract 1.

(And as Ken mentions, this would be good meta data to have in your Date/Time dimension, since you don't want each developer coming up with his/her own way of deriving it, if possible)

Try running the job with a small amount of data and see what happens to the sort scratch area.

eh?

You're scaring me...

I tried it under my account (not dsadm). Like shooting into the ground so as not to hurt anyone.

So I get "Insufficient privileges to perform lock maintenance." Good.

So if I do it as dsadm.... just what will get unlocked?

-Craig

I like that, Ray.

Is "unlock" available from the command line also?

Killing the PID is not the FIRST thing you want to do. Also, killing the PID of another user is only possible if you're root or have root privs. Even if you kill the PID, it won't unlock the job. First, try unlocking via Director. Second (I just go here first), determine the lock that is in place on...

It'd be easier, and processing time similar, if done in Server. Because... Looks like you'll need to process the file sequentially (no partitioning) since every row is dependent on the previous row. There appears to be no data that you can do hash partitioning on, so PX won't buy you much and you'll...

yes

Is there only one occurence of "<SecondOpenTab>" in the string? if so, you could do SOMETHING like: right(string,index(string,"<SecondOpenTab>",1) -1) : left(len(string) - index(string,"<SecondOpenTab>",1) + 15) In essence, you clip off the right and left side and conca...

I think you'll have trouble with the CFF stage. It needs something on every row to tell it which link to send it out. If the example is actual data, then there is marker row that says what follows. I'd use a transform stage and stage variables to determine which link to send the data, then the recei...

This is one of the questions I use to interview.

But the answers still aren't complete, missing a very basic difference, and wouldn't pass my interview.

Keep trying.

-Craig

Been there and observed the same behavior See my post "http://www.dsxchange.com/viewtopic.php?t=111348" You can't count on using the CDC stage when the key appears multiple times in the source (before) link. Bummer, huh? You need to do a join, then some fancy footwork if you plan on loadin...

Anyone know if the performance of a PX job is hindered by having 7 separate lookup stages vs. 1 lookup stage doing 7 lookups? Reason I have them busted out into 7 separate lookups is so that I can identify which lookup fails. I have a scheme cooking to identify them via a single lookup, but wonderin...

Is this by chance for an interview?

Is this by chance for an interview?