DSXchange

You're not required to import metadata, it can be created by hand. You could also create a temp table that looks like your MQT and then import from that.

Start by posting in the correct forum (the Site forum wasn't a proper place for this but I have moved it) and by letting us know your particulars - version, O/S, etc etc. Do this by going back and editing your original post - the one right above mine - now that you're in the correct forum that infor...

Jack, please start your own thread with your details rather than jumping oh here and saying you have the "same problem". That will go a long ways towards getting your problem solved.

OK... in the new release you can access the same core functionality built into the SKG stage directly in a Transformer via the tab you mentioned. And it's nicely documented in the docs in the 'Transformer stage: Surrogate Key tab:' section of the Parallel Job Developer Guide pdf. Don't see any burni...

So, now suddenly you are on the 8.x release rather than 7.1 in your other thread on this subject?

I have a requirement of implementing scd type2 where i want to insert the previous record and the updated record, in which i dont want to disable constraints, so for this i want to make use of composite primarykey for the key column and uniue sequence number. I don't see how any of that precludes y...

the Surrogate Key will do the same behavior if it is operat in parallel , to resolve that you should use either the Surrogate Key or the Tansformer in sequential mode If you are saying that the Surrogate Key Generator stage will "do the same" if not run sequential, as in not produce uniqu...

dsadm_ws wrote:Volume of data is about 10million records. No there are no indexes on the Target table.

Hoping you inferred from my question that "no indexes" would not be the preferred answer, yes?

Apples and oranges, of course.

What kind of volume are we talking about here? And since you are doing "updates only" are your key columns (the fields in your where clause) indexed in the target table?

You'll find several versions of the formula here if you do an exact search for NUMPARTITIONS in the forums, which should help answer your question. This one allegedly works fine.

Welcome.

Just for grins, why the "in transformer" part of your question? Why not use the stage that exists just to generate sequence numbers - i.e. the Surrogate Key Generator stage?

You really should have your own thread for all this. And at this point I'm just going to repeat the standard advice - do an exact search for the first line of your error message. Lots of ideas out there.

Hopefully by now there was one. I've got no idea what all might generate an error like that but I did an exact search here for "glibc detected" and got 23 hits... perhaps the answer was out there somewhere.

Aha! Had to be in there somewhere.

When you issue the "del #pathname##filename#" command, make sure there is no extra space there between the hash signs or in the two values.