Tag: technology

any number of any characters

any number of any characters surrounded by Q and E

literally \Q.*\E

literally .*

Range

Modulus

Entire

Same

memsize

arraysize

partitionsize

transactsize

one

two

Three

Many

same

Round Robin

Hash

Random

dsjob -run -mode NORMAL -instance <instance> <project> <job>

dsjob -run -mode NORMAL -wait -instance <instance> <project> <job>

dsjob -run -mode NORMAL <project> <job>.<instance>

dsjob -run -mode MULTI <project> <job>.<instance>

File sets are partitioned.

File sets are unpartitioned.

File sets are stored as a single file.

File sets are readable by external applications.

File sets are stored as header file and data files

Equality match

Negative match

Range on stream link

Range on the reject link

Range on the reference link

Specify only the key columns which are necessary.

Use the stable-sort option to avoid the random ordering of non-key data.

Minimize the number of sorts used within a job flow.

Adjusting the "Restrict Memory Usage" option in the Sort stage.

Run the job sequentially so that only one sort process is invoked.

Import using bridges.

Import a table definition using the Connector wizard.

Import DataStage components.

Import a table definition using the Plug-In Meta Data facility.