DSXchange

Users are created using unskilled labour.

User identities on the computer, on the other hand...

There is no Command tab that I can find. Attention to detail is vitally important for an ETL developer (or business analyst or many other professions). There is a command button captioned "Command" that opens a dialog in which commands may be entered in a project environment. But there is ...

OK, be more specific - "not working" does not convey anything useful. What precise error message is generated (copy/paste it from the job log - don't try to paraphrase or transcribe it).

Perhaps you'd like to share the answer, which is the normal convention when marking a DSXchange thread as Resolved.

Our last webinar was on this very topic. You can find this at http://www.dsxchange.net/webinar_training.html (or should be able to). If you can't find it. drop a note to editor@dsxchange.com or membershipdirectory@dsxchange.com who jointly look after these things.

Clearly you have NOT given all required credentials. Please advise which suite role(s) and which product role(s) you have allocated to this user.

Which of your stages is Sequential_File_0 ? (Assume rant about non-meaningfully-named stages.) Is it the reading stage or the writing stage? If it's the writing stage, do you have this set to overwrite or append?

Why is there a leading space in your SQL? Have you tried it without the terminating semi-colon?

Show me how the partition information is in an export file, as you claim. Then get yourself a premium membership and read the remainder of my previous post.

As design information this is not stored in a UniVerse table. Indeed it's not stored anywhere at design time. Partitioning is not determined until runtime, when the conductor process composes the score based upon two files: the osh script generated by compiling the job (which makes no mention of par...

Welcome aboard.

What is jpfile?

This can only be guaranteed to be the case if rows/transaction is 1.

An upstream Sort stage that generates a Key Change column and a downstream Remove Duplicates stage are valuable here too.

Using an explicit Sort stage allows YOU to control the resources allocated to sorting and, perhaps, the ability to assert that some or all of the key columns are already sorted/grouped. Relying upon DataStage to insert tsort operators means that you get default allocations, which may not be optimal.

Answered in server forum. The answer is no different in Enterprise Edition.