DSXchange

What are the stage types in your job design?

Something (some stage), somewhere in your job design, requires sorted input.

Then you are probably using a stage type that requires sorted input.

Then you are probably using a stage type that requires sorted input.

Is null genuine null or simply "missing"? There are ways to handle missing values, among them setting up VARTYPEs. Or you can convert the null values to something else upstream of the Match stage. To what values are your cutoffs set?

Trying to decode errors from APTCombinedOperatorController is a fool's errand. Disable operator combination and try again. At the very least you will learn which stage is generating the error. Also your question is confusing. Is the problem with View Data or is the problem with loading (and what do ...

Which part of "input not sorted" is unclear?

I'm not aware of any study guides apart from the student materials you receive when you attend an IBM class.

Make very sure that you have what you think you have, by viewing the file with something that also shows non-printing characters, such as the UNIX command od -c

Define "performance".

What rate can you get writing to a text file, without doing the bulk load? Would you be prepared to do that, and run the bulk load separately?

Int(InputField / 1000) : "." : Field(InputField, ".", 2, 1)

"Domain" really means Information Server, its associated services and all the products. It's the all-encompassing term.

Make very sure that you have what you think you have, by viewing the file with something that also shows non-printing characters, such as od -c

Also make sure that your metadata are correct, in particular that the quote character is the single quote (by default it is the double quote).

Then you are stuck with processing the huge number of columns.

C'est la vie.