DSXchange

GROUP.SIZE is in units of 2KB. Definitely not 1024KB. There is a storage overhead of three four-byte pointers per record. Straight away there's (190 x 12 = 2280 bytes). On average, a group will only fill to the SPLIT.LOAD threshold, so that each group buffer will contain only approximately (2048 x 0...

You won't get that from DSGetStageInfo().

Use a stage variable to keep the running total.

Add a reject link to the Lookup stage so that you can see exactly what values were sought.

Director client has a search facility.

It also has the ability to switch off display of Category, so that you can get all jobs in the project in a single listing. Look under the View menu.

Please delete the duplicate post. ( This one ) A Data Set stage reads from or writes to a Data Set, which is a parallel structure having data spread over all the processing nodes identified in the current configuration file when it is written. Data Sets store data in DataStage internal format, for ...

Aha! A Distributed file. You must first remove all the part files from the Distributed file before you can delete the individual part files (hashed files). DEFINE.DF HSH_PESS REMOVING HSH_NJ_PESS_01_0 HSH_NJ_PESS_01_1 HSH_NJ_PESS_01_2 HSH_NJ_PESS_01_3 HSH_NJ_PESS_01_4 HSH_NJ_PESS_01_5 HSH_NJ_PESS_01...

Use the score to determine which operators are involved in this particular combination, or disable combination to determine in which operator the error was reported. This will help you to narrow the focus of your detective efforts.

FirstPart : Fmt(@INROWNUM, "R%4")

I don't think that's possible in a WHERE clause. Only in a SELECT clause. But I could be wrong. Don't have access to an Oracle database today to test it.

Does the copy parameter utility support encrypted environment variables?

What do you mean by a "hash partitioned"?

The commands you give relate to hashed files. These are not partitioned.

What are you trying to achieve?
What, precisely, did you create, and by what means? Be precise and explicit in your description.

Yes, if your logic is that posted by satya99.

In server jobs the Merge stage supports all types of join, but only between two text files. You do, of course, require a key field (or more than one) on which to base the join condition.

As Craig noted, server jobs do not have a Join or a Lookup stage.

Welcome aboard. :D

Etiquette Note
We don't hijack threads. This is not the identical problem, and will have a different solution, so you must start a new thread.

Try right click and "open in new window".

If you're using IE, hover the mouse pointer over the link and note the URL displayed in the status bar at the bottom of the screen.

It's working fine for me (IE6).