DSXchange

One possible solution, assuming you are using IS 8.5 or later: Add a column with 1, 2 or 3 to identify which source the record belongs to EDITED Partition the combined records on the key columns Sort on the key columns and source column In a transformer: - identify key changes by comparing the incom...

Chandra, I didn't see anything that necessitated a comment or correction :) What you stated is correct. The Advanced DataStage class is beneficial as it is more in-depth than the DataStage Essentials class in how the engine works. Do you need to take it? I don't know that you need to, but I consider...

xinhuang: 1) I've personally not heard of this issue from support, but I'll defer to them and engineering. It sounds as if it's something specific to your situation, as I have not encountered it before. 2-4) The requirement for key partitioning DOES NOT mean that the developer has to explicitly spec...

Not with the join stage.

What would/needs to happen if there is more than one row in T2 with column a = 0?
Is the row with 0 meant to be a "default" value for c if there is no match on a?

Regards,

To all who are questioning: The "Auto" partitioning method simply instructs the parallel engine (i.e. Orchestrate) to choose an appropriate partition method at runtime , provided that Auto Partitioning has not been overridden or disabled by "Preserve Partitioning", $APT_NO_PART_I...

You are reasonably correct. Auto partitioning will guarantee that the partitioning method chosen (if necessary) will meet the needs of the stage requiring said partitioning. As part of job performance tuning, your job may be able to take advantage of specific key partitioning techniques (which auto ...

I always forget about that one....

As Ray suggested earlier in the thread, use the Monitor tool in Director to see how the data has been distributed among the nodes at the points in your job you are assigning the sequence number. If the distribution varies by more than one row from min to max, you will see gaps. If it varies by only ...

In our layout we are having some columns as comp-3 decimal and some are character We are generating that files in binary mode and the mainframes is ftp in ascii mode Generate the file so that character data is using the EBCDIC character set and there are no record delimiters (Complex Flat File can ...

Are all of your data columns binary (comp-3, comp, etc.) or do you also have some that are character data? If you are using FTP in ASCII-mode to transfer a file from a system that is ASCII-based (Unix/Windows) to a system that is EBCDIC-based (z/OS), FTP will attempt to convert, on a byte-by-byte ba...

In a transformer stage, link ordering simply describes the order in which the output links (constraints and derivations) are processed. If you are using the "otherwise" constraint option for only one of the output links (to capture any records that did not get written to any other links), ...

No. If RG is executing sequentially, that means that it is executing on ONE node.

1 row * 1 node = 1 total rows

The number of rows you provide is per-node.

Total Rows Generated = Number of Rows Requested * Number of Nodes that RG executes on.

If RG is sequential (which is the default):
1 * 1 = 1

Regards,

The number of rows you provide is per-node.

Total Rows Generated = Number of Rows Requested * Number of Nodes that RG executes on.

If RG is sequential (which is the default):
1 * 1 = 1

Regards,

ONLY if you are round-robin partitioning a sequential source. If you round-robin an already-partitioned data source, you can get gaps in the assignment.

Regards,