datastage常用术语



 DataStage Term                    DescriptionDataStage AdministratorClient program that is used to manage the project of DataStage.DataStage serverDataStage server engine component that links to DataStage client programs.DataStage DirectorExecution and monitoring of the program that you want to use DataStage job.DataStage DesignerGraphical design tool that developers use to design and development of the DataStage job.DataStage ManagerProgram used to manage the contents of the repository and see DataStage. Please refer to the "DataStage Manager Guide."StageComponent that represents the data source for DataStage job, and process steps.SourceI pointed to the source of data extraction. STEPS, such as, for example.TargetRefers to the destination of the data. For example, point to the file to be loaded to AML (output by DataStage).CategoryCategory names used to categorize the jobs in DataStage.ContainerProcess of calling a common process.JobProgram that defines how to do data extraction, transformation, integration, and loading data into the target database.Job templatesAnd job processing is performed similar role model.Job parametersVariables that are included in the job design. (For example,. Is the file name and password, for example)Job sequenceControl is a job for a start and run other jobs.Scratch diskDisk space to store the data set, such as virtual record.Table definitionDefinition that describes the required data includes information about the associated data tables and columns. Also referred to as metadata.PartitioningFor high-speed processing of large amounts of data, the mechanism of DataStage to perform split of the data.Parallel engineEngine running on multiple nodes to control jobs DataStage.Parallel jobsAvailable to parallel processing, the DataStage job type.ProjectJobs and a collection of components required to develop and run. The entry level to DataStage from the client. DataStage project must be licensed.MetadataData about the data. For example, a table definition that describes the columns that are building data.LinkEach stage of the job combined to form a data flow or reference lookup.RoutineFunctions that are used in common.Column definitionDefine the columns to be included in the data table. Contains the names and data types of the columns that make up the column.Environmental parametersVariables that are included in the job design. For example, the file name and password.DB2 stageStage to be able to read and write to DB2 database.FileSet stageCollection of files used to store the data.Lookup StagePerforming processing such as a file reference to be used in DataStage or text file or table.LookupFileSet StageThe process of storing a lookup table.Sequential StageWant to manipulate text files.Custom StageThe process can not be implemented in stages, which is provided as standard DataStage, the process of implementing the language C.Copy StageThe process of copying the data set.Stage GeneratorThe process of generating a dummy data set.DataSet stageData file to be used in the parallel engine.Funnel StageThe process of copying the data from one set of multiple data sets.Filter StageProcessing to extract records from the input data set.Merge StageProcessing the join more than one input record.LinkCorrector StageProcess of collecting the data that was previously divided.RemoveDuplicate StageThe process of removing duplicate entries from the data set.ChangeCapture StageThe process of comparing the two data sets, the difference between the two records.RowImport StageProcess of importing a column from a string or binary column.RowExport StageProcessing to export a column of another type string or binary column.Transformer StageProcessing to edit item, or type conversion.Modify StageProcess of conversion to the specified data type, the conversion of the value to the specified value NULL.XML input stageReading and processing of XML file, the extraction of the required element from the XML data.Sort StageProcess to sort data in ascending or descending order.Join StageProcessing the join more than one input record.RowGenerator StageProcess of adding a line to an existing datasetColumnGenerator StageProcess of adding a column to an existing datasetAggregator stageThe process of aggregating the data.Pivot StageThe process of converting multiple columns into multiple rows of records.Peek StageTreatment to destroy the records.Stream linkLink that represents the flow of data.Reference LinksInput link that represents the reference data.Reject linkLink to output the data that do not meet the criteria you specify.Integer typeData type that represents the integer value.Decimal typeData type represents a number that contains the value of the decimal point.NULL valueSpecific value indicating the unknown value. 0, not the same as a blank or empty sequence.DataSetCollection of data.SQLStatementStatement to manipulate the data in the table.TWSStands for Tivoli Workload Scheduler. The name of the product you want to create a job net.HashOne way of dividing the data specified in the partitioning function of DataStage. Partitioning is performed by using a hash value.ModulusOne 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.SameOne 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.Job PropertiesProperty sheet to make settings for the job.