B Default Groups and Parameters

When you use OMB Plus to add an operator to a mapping, Warehouse Builder adds the operator and assigns default groups and parameters. This appendix lists the default groups and parameters for each operator.

This appendix includes the following topic:

• Default Group Names and Attribute Names

Default Group Names and Attribute Names

Table B–1 lists the default groups and attributes that are created when an operator is added.

Table B-1 Default Names for Groups and Attributes

Operator Type	Default Operator Name	Default Group Name	Default Attribute Name
TABLE VIEW EXTERNAL TABLE MATERIALIZED VIEW CUBE DIMENSION	Same as bound object name	INOUTGRP1	Same as column names
FLAT FILE	Object name	Same as file record name	Same as field names in each record
SEQUENCE	Same as sequence name	OUTGRP1	NEXTVAL CURRVAL
DATAGENERATOR	DATAGENERATOR	OUTGRP1	RECNUM SYS_DATE SEQUENCE
CONSTANT	CONST	OUTGRP1	No defaults
KEY LOOKUP	Object name	INGRP1 OUTGRP1	In LOOKUP_OUT object column names
SET	SET	INGRP1 INGRP2 OUTGRP1	None
JOINER	JOIN	INGRP1 INGRP2 OUTGRP1	None
SPLITTER	SPLIT	INGRP1 OUTGRP1 OUTGRP2 REMAINING_ROWS	None
DEDUPLICATOR	DEDUP	INOUTGRP1	None
AGGREAGTOR	AGG	INGRP1 OUTGRP1	None
FILTER	FLTR	INOUTGRP1	None
SORTER	SORT	INOUTGRP1	None
NAME AND ADDRESS	NAMEADDR	INGRP1 OUTGRP1	Within Group INGRP1: Line 1, Line 2, Line 3 Within Group OUTGRP1: First Name, Last Name, Primary Address, Secondary Address, City, State, Postal Code, Is Good Group
PROCEDURES	Procedure name	If input parameter exists, an input group will be created with the name INGRP1. If ouput parameter exists, an output group will be created with the name OUTGRP1. If inout parameter exists, an input-output group will be created with the name INGRP1.	Same as parameter names
FUNCTIONS	Same as function name	INGRP1, RETURN	An attribute
TRIGGER	PREMAP POSTMAP	Nameing see PROCEDURES and FUNCTIONS	None
INPUT_PARAMETER	MAP_INPUTS	MAP_INPUTS	None
OUTPUT_PARAMETER	MAP_OUTPUTS	MAP_OUTPUTS	None
EXTERNAL_PROCESS	EXTERNALPROCESS	None	None
EXPRESSION	EXPR	INGRP1 OUTGRP1	None