DSXchange

Be careful, sometimes names can turn on you. I have a hard time not laughing every time a commercial for this new drug called 'Aciphex' comes on TV. All I hear is 'Ass Effects' and think - that can't be a good thing!

I tried your code but its giving svSeqNo 1 for all the records. I honestly don't see how that is possible. Verify some things for me. 1) You created the stage variables in the order shown 2) You created the derivations as shown, adjusted for your actual names 3) You set the Initial Values on the Pr...

There's no upper limit of '2' to this sequence that Edward M has mentioned. svTargetType -> Link.RecType = 605 svCurrKey -> Link.InvNo : '|' : Link.RecType svNewKey -> svCurrKey <> svPrevKey svSeqNo -> If svTargetType Then If svNewKey Then 1 Else svSeqNo + 1 Else svSeqNo svPrevKey -> svCurrKey Off t...

Do whatever you like as long as it works and you get the 'all' versus 'any' setting correct in the Sequencers.

Call it from a UserVariables stage, that can then feed them to the Start Loop.

So Roy - are you moderating *all* groups now or just literally the ones that list you as the moderator?

You need to adapt what Maveric posted with the details in my post. He has missed the point that the sequence number needs to reset back to 1 when the "Inv.No" changes... the 'x' mentioned in my post.

And the first stage variable isn't really needed.

Kim, perhaps we could relieve Ray of at least one of his onerous duties - running around and posting 'Mod..., please move to' messages.

That would help even the numbers.

Your hashed file is corrupted. Search the forums for 'computed blink' to find several conversations on what a 'backwards link' is and how it got horked up. Typically your 32bit hashed file exceeded the 2.2GB boundary and needs to be 64bit...

That just looks like a job for Stage Variables and 'group change detection' to me. Check for 'x 605' and for every time you see a new value of 'x' set a sequence number stage variable's value to 1. As long as 'x' doesn't change, increment the sequence number for each occurance of '605'. This will wo...

dlkkrao wrote:A number of columns used to process the dimensions (such as src_key columns) do not have indexes. Since lookups use these columns extensively, adding indexes will greatly speed up loading performance.

True, that. Well, except maybe for the 'greatly' part.

So... your issue is resolved?

Not sure what you are expecting. DIRECT=FALSE,PARALLEL=FALSE means single threaded inserts. Buffered, yes, but a conventional path load nonetheless. And with fifty-seven indexes...

kduke wrote:Just exactly how far behind am I now?

Well, let's see... 22689 - 3769... (naught, naught, carry the naught)... only 18,930 posts to go! :D