DSXchange

Try setting the NLS map (in the job or in the stage if you prefer) to NONE.

They won't start instantaneously at the same time but they should be able to run in parallel. Check out the generated Job Control code to figure out what's happening.

Once you clean these processrun the othercommand which i gave.. netstat -aA|grep dsrpc and these command will give you addresses which are ocuuoied by the ports and then u can clean those address useing rmsock.. U is in Singapore, rohitaagarqwal15 is not, as far as I am aware. I don't think it will...

The DSXchange Learning Center has a DVD called "Programming with DataStage BASIC" which is mainly about routines (and expressions) written in that language. DSD_STAGE.H is a header file containing constant and variable definitions such as STAGECOM.NAME, CONTAINER.PARAM.NAMES and STAGECOM.J...

None of what pandeesh suggested will work with the Modify stage. They are functions to be used in a Transformer stage. Typically Transformer stage functions have "To" names, like StringToDecimal(), whereas Modify stage functions have "_from_" names, like decimal_from_string() or ...

Probably. Try it and let us know. You might also like to time the two approaches with the same set of data. (You may be surprised.)

Yes, sorted on all eight grouping fields. It doesn't matter how or where you do that sorting.

What was the NLS setting in the previous project? How did you move the hashed files? Is there a non-default NLS setting in the job?

Well, if you're using hashed files, you may as well use the Key Management routines in the SDK for working with them.

Not necessarily in a Sort stage (though I'd advocate that) but it's essential that they're sorted.

Or you could use a before-job subroutine (ExecTCL) to create the hashed file. It will, of course, be empty of both data and metadata if you do it this way, but it will still work.

You might need to wait until the next time U logs in if that's what you want.

The second person personal pronoun in English is spelled "you".

If you change the method to sort without sorting your data (implied by your use of the word "simply"), the impact will be that your job aborts.

Got to wonder why they have an ErWin logical model but no physical model! That one at least is easy. Apparently there are circular references in the logical model (ERwin doesn't care) that prevent ERwin from generating the physical model properly. There are also issues with too many generated physi...

Depends what you mean by "adverse effects" I guess.

You should get identical results using either method. With sorted data you'll get them faster through the Aggregator stage, but much of that gain may be taken up sorting the data.