datastage常用术语

淩亂°似流年 2022-06-10 14:37 366阅读 0赞

<table style="width:731px"> 
 <tbody> 
  <tr style="height:12pt"> 
   <td style="background:rgb(79,129,189); border:0.5pt solid windowtext; width:117pt; height:12pt; color:white; font-family:'ＭＳ ゴシック'; font-size:10pt; font-weight:700; text-decoration:none"> &nbsp;DataStage Term</td> 
   <td style="background:rgb(79,129,189); border:0.5pt solid windowtext; width:431pt; color:white; font-family:'ＭＳ ゴシック'; font-size:10pt; font-weight:700; text-decoration:none"> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Description</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> DataStage Administrator</td> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Client program that is used to manage the project of DataStage.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> DataStage server</td> 
   <td style="border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> DataStage server engine component that links to DataStage client programs.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> DataStage Director</td> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Execution and monitoring of the program that you want to use DataStage job.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> DataStage Designer</td> 
   <td style="border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Graphical design tool that developers use to design and development of the DataStage job.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> DataStage Manager</td> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Program used to manage the contents of the repository and see DataStage. Please refer to the "DataStage Manager Guide."</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Stage</td> 
   <td style="border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Component that represents the data source for DataStage job, and process steps.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Source</td> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> I pointed to the source of data extraction. STEPS, such as, for example.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Target</td> 
   <td style="border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Refers to the destination of the data. For example, point to the file to be loaded to AML (output by DataStage).</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Category</td> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Category names used to categorize the jobs in DataStage.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Container</td> 
   <td style="border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Process of calling a common process.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Job</td> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Program that defines how to do data extraction, transformation, integration, and loading data into the target database.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Job templates</td> 
   <td style="border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> And job processing is performed similar role model.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Job parameters</td> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Variables that are included in the job design. (For example,. Is the file name and password, for example)</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Job sequence</td> 
   <td style="border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Control is a job for a start and run other jobs.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Scratch disk</td> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Disk space to store the data set, such as virtual record.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Table definition</td> 
   <td style="border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Definition that describes the required data includes information about the associated data tables and columns. Also referred to as metadata.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Partitioning</td> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> For high-speed processing of large amounts of data, the mechanism of DataStage to perform split of the data.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Parallel engine</td> 
   <td style="border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Engine running on multiple nodes to control jobs DataStage.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Parallel jobs</td> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Available to parallel processing, the DataStage job type.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Project</td> 
   <td style="border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Jobs and a collection of components required to develop and run. The entry level to DataStage from the client. DataStage project must be licensed.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Metadata</td> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Data about the data. For example, a table definition that describes the columns that are building data.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Link</td> 
   <td style="border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Each stage of the job combined to form a data flow or reference lookup.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Routine</td> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Functions that are used in common.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Column definition</td> 
   <td style="border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Define the columns to be included in the data table. Contains the names and data types of the columns that make up the column.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Environmental parameters</td> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Variables that are included in the job design. For example, the file name and password.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> DB2 stage</td> 
   <td style="border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Stage to be able to read and write to DB2 database.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> FileSet stage</td> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Collection of files used to store the data.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Lookup Stage</td> 
   <td style="border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Performing processing such as a file reference to be used in DataStage or text file or table.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> LookupFileSet Stage</td> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> The process of storing a lookup table.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Sequential Stage</td> 
   <td style="border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Want to manipulate text files.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Custom Stage</td> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> The process can not be implemented in stages, which is provided as standard DataStage, the process of implementing the language C.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Copy Stage</td> 
   <td style="border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> The process of copying the data set.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Stage Generator</td> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> The process of generating a dummy data set.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> DataSet stage</td> 
   <td style="border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Data file to be used in the parallel engine.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Funnel Stage</td> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> The process of copying the data from one set of multiple data sets.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Filter Stage</td> 
   <td style="border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Processing to extract records from the input data set.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Merge Stage</td> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Processing the join more than one input record.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> LinkCorrector Stage</td> 
   <td style="border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Process of collecting the data that was previously divided.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> RemoveDuplicate Stage</td> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> The process of removing duplicate entries from the data set.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> ChangeCapture Stage</td> 
   <td style="border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> The process of comparing the two data sets, the difference between the two records.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> RowImport Stage</td> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Process of importing a column from a string or binary column.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> RowExport Stage</td> 
   <td style="border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Processing to export a column of another type string or binary column.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Transformer Stage</td> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Processing to edit item, or type conversion.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Modify Stage</td> 
   <td style="border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Process of conversion to the specified data type, the conversion of the value to the specified value NULL.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> XML input stage</td> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Reading and processing of XML file, the extraction of the required element from the XML data.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Sort Stage</td> 
   <td style="border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Process to sort data in ascending or descending order.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Join Stage</td> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Processing the join more than one input record.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> RowGenerator Stage</td> 
   <td style="border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Process of adding a line to an existing dataset</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> ColumnGenerator Stage</td> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Process of adding a column to an existing dataset</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Aggregator stage</td> 
   <td style="border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> The process of aggregating the data.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Pivot Stage</td> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> The process of converting multiple columns into multiple rows of records.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Peek Stage</td> 
   <td style="border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Treatment to destroy the records.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Stream link</td> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Link that represents the flow of data.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Reference Links</td> 
   <td style="border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Input link that represents the reference data.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Reject link</td> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Link to output the data that do not meet the criteria you specify.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Integer type</td> 
   <td style="border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Data type that represents the integer value.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Decimal type</td> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Data type represents a number that contains the value of the decimal point.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> NULL value</td> 
   <td style="border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Specific value indicating the unknown value. 0, not the same as a blank or empty sequence.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> DataSet</td> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Collection of data.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> SQLStatement</td> 
   <td style="border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Statement to manipulate the data in the table.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> TWS</td> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Stands for Tivoli Workload Scheduler. The name of the product you want to create a job net.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Hash</td> 
   <td style="border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> One way of dividing the data specified in the partitioning function of DataStage. Partitioning is performed by using a hash value.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Modulus</td> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> One way of dividing the data specified in the partitioning function of DataStage. I do partitioning by dividing the number of partitions in the specified value.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Same</td> 
   <td style="border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> One way of dividing the data specified in the partitioning function of DataStage. Processing as input partition without subdivision has been output by the previous stage.</td> 
  </tr> 
  <tr style="height:12.75pt"> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; height:12.75pt; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Job Properties</td> 
   <td style="background:rgb(220,230,241); border:0.5pt solid windowtext; color:black; font-family:Calibri; font-size:10pt; font-weight:400; text-decoration:none"> Property sheet to make settings for the job.</td> 
  </tr> 
 </tbody> 
</table>