DSXchange

In 7.5 and earlier the tools are all independent of each other. Only DataStage uses the "UniVerse" database. The Reporting Assistant should still be available in 7.5, but had not been officially supported since (I think) version 7.0. If you use MetaStage, you can store metadata from many t...

Dump the score and examine it.

From almost four years ago?

I am trying to teach the OP to fish, rather than to give fish, which has a shorter duration benefit.

Auto will cause Hash to be chosen. Search for other posts on this topic.

Sort will always separately sort the records on the individual nodes (partitions).

Make sure it IS exactly the same. Parameter Set names are case sensitive.

If there are other underscores in your data, limit the operation of sed to the first line of the file.

You can only pass a Parameter Set from a sequence to a Job activity when the job itself refers to that Parameter Set.

Have you tried passing a Parameter Set element (parameter) using dot notation (setname.parametername) as appropriate?

If you specify a sort/merge collector on the Sequential File stage input link, it will preserve sorted order.

You will need a script, though you can run that from an after-job subroutine (ExecSH). Use something like sed to effect the change.

The Sequential File stage runs on one node (because the file only exists on one node). Each increase of 1 in number of readers per node will cause an increase of 1 in the number of processes executing on this node - which you should have seen if you were monitoring the job score thoroughly.

That suggests that you have not write permission to the DSParams file in the project, where these values are stored.

Fact tables tend to be referencing tables. Dimensions are referenced from the fact tables.

However, sometimes you will find "snowflakes" in the design. A table that is both referenced and referencing is likely to be a dimension, with the table it references being a "snowflake".

You're not even familiar with the syntax of chmod command. Find someone who has knowledge and permission.

Note: the better solution is to be granted membership of the correct group. should not be used as a universal panacea. They won't allow that in production.