$Header:$
#!-------------------------------------------------------------------
#! Oracle Warehouse Builder Export Data File  02/22/2005 1:22:09 PM
#!   RELEASE=10.1.0.2.0  OWB REPOSITORY VERSION=10.1.0.1.0
#!   EXPORTUSER=owb_rep  CONNECTSTRING=(DESCRIPTION=(ADDRESS=(HOST=singapore)(PROTOCOL=tcp)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=bdev.bayontechnologies.com)))
#!-------------------------------------------------------------------
#
DATASOURCE=OWB
MDLRELEASE=9.2
RELEASE=10.1.0.2.0
FIELDSEPARATOR=|
#
CHARACTERSET=WE8MSWIN1252
#
#Base Language <ISOLanguageID> <LanguageName>
BASELANGUAGE|en_US|American English
#
#Project  <PhysicalName> <LogicalName> <UniversalID> <VersionLabel>
PROJECT|PSOUG_FEB23|PSOUG_FEB23|F0B5E976B448741CE030A8C0FACA4FFB|null
#
#Location  <PhysicalName> <LogicalName> <UniversalID> <LocType> <LocTypeVersion> <DefaultFlag> <DataSourceFlag> <DataTargetFlag> <FrozenFlag>
LOCATION|PAYROLL_L|PAYROLL_L|F0B5E976B79B741CE030A8C0FACA4FFB|File System|0|N|N|N|N
#
#Location  <PhysicalName> <LogicalName> <UniversalID> <LocType> <LocTypeVersion> <DefaultFlag> <DataSourceFlag> <DataTargetFlag> <FrozenFlag>
LOCATION|BDEV_OWF_MGR|BDEV_OWF_MGR|F0B7BABADAFA4CDCE030A8C0FACA52BB|Oracle Workflow|2.6.3|N|N|N|N
#
#Location  <PhysicalName> <LogicalName> <UniversalID> <LocType> <LocTypeVersion> <DefaultFlag> <DataSourceFlag> <DataTargetFlag> <FrozenFlag>
LOCATION|OWB_TST_L|OWB_TST_L|F0B5E976B44B741CE030A8C0FACA4FFB|Oracle Database|10.1|N|N|N|N
#
#Location  <PhysicalName> <LogicalName> <UniversalID> <LocType> <LocTypeVersion> <DefaultFlag> <DataSourceFlag> <DataTargetFlag> <FrozenFlag>
LOCATION|SCOTT_L|SCOTT_L|F0B5E976B596741CE030A8C0FACA4FFB|Oracle Database|10.1|N|N|N|N
#
#Connector  <PhysicalName> <LogicalName> <UniversalID> <Owning Location Name> <Owning Location UniversalID> <Target Location Name> <Target Location UniversalID>
CONNECTOR|OWB_TST_L_SCOTT_L|OWB_TST_L_SCOTT_L|F0B5E976B615741CE030A8C0FACA4FFB|OWB_TST_L|F0B5E976B44B741CE030A8C0FACA4FFB|SCOTT_L|F0B5E976B596741CE030A8C0FACA4FFB
#
#Runtime Repository Connection  <PhysicalName> <LogicalName> <UniversalID> <LocType> <LocTypeVersion> <DefaultFlag> <UserName> <Schema> <Host> <Port> <SID>
RUNTIMEREPOSITORYCONNECTION|BDEV_OWB_RT|BDEV_OWB_RT|F0B5E976B449741CE030A8C0FACA4FFB|null|null|N|owb_user|owb_rt|singapore|1521|bdev.bayontechnologies.com
#
#File Installed Module  <PhysicalName> <LogicalName> <UniversalID> <Typecode> <Logical> <CanBeSource> <CanBeHub> <CanBeWarehouse>
#     <Status> <System> <SystemType(SoftwareModuleVersion)> <Integrator> <ApplicationType>
#     <DatabaseLink> <MetadataImported> <Directory> <NameFilter> <ApplyFilter> <LocationName> <LocationUniversalID>
FILEINSTALLEDMODULE|PAYROLL|PAYROLL|F0B5E976B79A741CE030A8C0FACA4FFB|null|null|Y|N|N|DEV_STATUS|null|Generic File System|Oracle OWB Integrator for Flat Files 3.0|Generic File Based Application|null|null|E:\ngoodman\psoug_data|null|N|PAYROLL_L|F0B5E976B79B741CE030A8C0FACA4FFB
#
#File <PhysicalName> <LogicalName> <UniversalID> <CharacterSetEncoding> <SourceFrom>
#     <FIXED/DELIMITED> <PhysicalRecordSize> <PhysicalRecordNumber>
#     <LineContinuationChar> <LineContinuationCharPos> <LineContinuationCharOnNextLineFlag>
#     <FieldDelimiter> <StringEnclosure> <RecordDelimiter> <RecordClassifierLength> <RecordClassifierPosition>
#     <SkipRecords> <SelfDescribingFlag> <Imported>
FILE|payroll_detail_thru2004_txt|payroll_detail_thru2004_txt|F0B5E976B7A2741CE030A8C0FACA4FFB|WE8MSWIN1252|payroll_detail_thru2004.txt|DELIMITED|0|1|null|0|Y|\t|null|<CR>|0|0|0|N|Y
#
#Record <PhysicalName> <LogicalName> <UniversalID> <RecordClassifier> <RecordSize>
RECORD|payroll_detail_thru2004_txt|payroll_detail_thru2004_txt|F0B5E976B7A3741CE030A8C0FACA4FFB|null|0
#Field <PhysicalName> <LogicalName> <UniversalID> <DataType> <Length>
#     <Scale> <OrdinalPosition> <Mask> <StartPosition> <EndPosition> <NullIfValue> <DefaultIfValue>
#     <Precision> <SQLDataType> <SQLLength> <SQLPrecision> <SQLScale>
FIELD|PayrollId|PayrollId|F0B5E976B7A4741CE030A8C0FACA4FFB|INTEGER EXTERNAL|9|0|1|null|0|0|null|null|0|null|0|0|0
FIELD|EmployeeId|EmployeeId|F0B5E976B7A5741CE030A8C0FACA4FFB|INTEGER EXTERNAL|10|0|2|null|0|0|null|null|0|null|0|0|0
FIELD|PayrollAmount|PayrollAmount|F0B5E976B7A6741CE030A8C0FACA4FFB|INTEGER EXTERNAL|13|0|3|null|0|0|null|null|0|null|0|0|0
#
#File <PhysicalName> <LogicalName> <UniversalID> <CharacterSetEncoding> <SourceFrom>
#     <FIXED/DELIMITED> <PhysicalRecordSize> <PhysicalRecordNumber>
#     <LineContinuationChar> <LineContinuationCharPos> <LineContinuationCharOnNextLineFlag>
#     <FieldDelimiter> <StringEnclosure> <RecordDelimiter> <RecordClassifierLength> <RecordClassifierPosition>
#     <SkipRecords> <SelfDescribingFlag> <Imported>
FILE|payroll_data_thru2004_csv|payroll_data_thru2004_csv|F0B5E976B79C741CE030A8C0FACA4FFB|WE8MSWIN1252|payroll_data_thru2004.csv|DELIMITED|0|1|null|0|Y|,|null|<CR>|0|0|1|N|Y
#
#Record <PhysicalName> <LogicalName> <UniversalID> <RecordClassifier> <RecordSize>
RECORD|payroll_data_thru2004_csv|payroll_data_thru2004_csv|F0B5E976B79D741CE030A8C0FACA4FFB|null|0
#Field <PhysicalName> <LogicalName> <UniversalID> <DataType> <Length>
#     <Scale> <OrdinalPosition> <Mask> <StartPosition> <EndPosition> <NullIfValue> <DefaultIfValue>
#     <Precision> <SQLDataType> <SQLLength> <SQLPrecision> <SQLScale>
FIELD|Payroll_Date|Payroll_Date|F0B5E976B79E741CE030A8C0FACA4FFB|CHAR|12|0|1|null|0|0|null|null|0|null|0|0|0
FIELD|PayrollID|PayrollID|F0B5E976B79F741CE030A8C0FACA4FFB|INTEGER EXTERNAL|9|0|2|null|0|0|null|null|0|null|0|0|0
FIELD|EmployerCode|EmployerCode|F0B5E976B7A0741CE030A8C0FACA4FFB|CHAR|12|0|3|null|0|0|null|null|0|null|0|0|0
FIELD|PayrollType|PayrollType|F0B5E976B7A1741CE030A8C0FACA4FFB|CHAR|11|0|4|null|0|0|null|null|0|null|0|0|0
#
#DataWarehouse Installed Module  <PhysicalName> <LogicalName> <UniversalID> <Typecode> <Logical> <CanBeSource> <CanBeHub> <CanBeWarehouse>
#     <Status> <System> <SystemType(SoftwareModuleVersion)> <Integrator> <ApplicationType>
#     <DatabaseLink> <MetadataImported> <ImportTable> <ImportView> <ImportSynonym>
#     <ImportSequence> <Schema> <NameFilter> <ApplyFilter> <MetadataDBLink> <LocationName> <LocationUniversalID>
DATAWAREHOUSE|OWB_TST|OWB_TST|F0B5E976B44A741CE030A8C0FACA4FFB|DATABASE_DICTIONARY.|null|N|Y|Y|DEV_STATUS|null|Oracle Database 8i/9i/10g|Oracle OWB Integrator for Oracle DB and Apps 3.0|Oracle Warehouse Application|null|null|Y|Y|Y|Y|null|null|N|null|OWB_TST_L|F0B5E976B44B741CE030A8C0FACA4FFB
#Configuration Parameter  <GroupPhysicalName> <ParamPhysicalName> <ParamValue> <DefaultValue> <UniversalID>
CONFIGPARAM|8i.ORACLE8.1.IDENTIFICATION|8i.ORACLE8.1.MAINAPP|ora|Y|null
CONFIGPARAM|8i.ORACLE8.1.IDENTIFICATION|8i.ORACLE8.1.SHORTNAME|wb|Y|null
CONFIGPARAM|8i.ORACLE8.1.IDENTIFICATION|8i.ORACLE8.1.SCHEMAOWNER|owb|Y|null
CONFIGPARAM|8i.ORACLE8.1.IDENTIFICATION|8i.ORACLE8.1.CONNECTSTRING|null|Y|null
CONFIGPARAM|8i.ORACLE8.1.IDENTIFICATION|8i.ORACLE8.1.JDBCSERVER|null|Y|null
CONFIGPARAM|8i.ORACLE8.1.IDENTIFICATION|8i.ORACLE8.1.JDBCPORT|null|Y|null
CONFIGPARAM|8i.ORACLE8.1.IDENTIFICATION|8i.ORACLE8.1.JDBCSERVICENAME|null|Y|null
CONFIGPARAM|8i.ORACLE8.1.IDENTIFICATION|8i.ORACLE8.1.APPTOPDIRECTORY|..\..\codegen\|Y|null
CONFIGPARAM|8i.ORACLE8.1.IDENTIFICATION|8i.ORACLE8.1.DEPLOYABLE|true|Y|null
CONFIGPARAM|8i.ORACLE8.1.GENDIRECTORIES|8i.ORACLE8.1.TCLDIRECTORY|tcl\|Y|null
CONFIGPARAM|8i.ORACLE8.1.GENDIRECTORIES|8i.ORACLE8.1.DDLDIRECTORY|ddl\|Y|null
CONFIGPARAM|8i.ORACLE8.1.GENDIRECTORIES|8i.ORACLE8.1.DDLEXTENSION|.ddl|Y|null
CONFIGPARAM|8i.ORACLE8.1.GENDIRECTORIES|8i.ORACLE8.1.DDLSPOOLDIRECTORY|ddl\log\|Y|null
CONFIGPARAM|8i.ORACLE8.1.GENDIRECTORIES|8i.ORACLE8.1.LIBDIRECTORY|lib\|Y|null
CONFIGPARAM|8i.ORACLE8.1.GENDIRECTORIES|8i.ORACLE8.1.LIBEXTENSION|.lib|Y|null
CONFIGPARAM|8i.ORACLE8.1.GENDIRECTORIES|8i.ORACLE8.1.LIBSPOOLDIRECTORY|lib\log\|Y|null
CONFIGPARAM|8i.ORACLE8.1.GENDIRECTORIES|8i.ORACLE8.1.PLSDIRECTORY|pls\|Y|null
CONFIGPARAM|8i.ORACLE8.1.GENDIRECTORIES|8i.ORACLE8.1.PLSEXTENSION|.pls|Y|null
CONFIGPARAM|8i.ORACLE8.1.GENDIRECTORIES|8i.ORACLE8.1.PLSRUNPRM|_run.ini|Y|null
CONFIGPARAM|8i.ORACLE8.1.GENDIRECTORIES|8i.ORACLE8.1.PLSSPOOLDIRECTORY|pls\log\|Y|null
CONFIGPARAM|8i.ORACLE8.1.GENDIRECTORIES|8i.ORACLE8.1.ABAPDIRECTORY|abap\|Y|null
CONFIGPARAM|8i.ORACLE8.1.GENDIRECTORIES|8i.ORACLE8.1.ABAPEXTENSION|.abap|Y|null
CONFIGPARAM|8i.ORACLE8.1.GENDIRECTORIES|8i.ORACLE8.1.ABAPRUNPRM|_run.ini|Y|null
CONFIGPARAM|8i.ORACLE8.1.GENDIRECTORIES|8i.ORACLE8.1.ABAPSPOOLDIRECTORY|abap\log\|Y|null
CONFIGPARAM|8i.ORACLE8.1.GENDIRECTORIES|8i.ORACLE8.1.CTLDIRECTORY|ctl\|Y|null
CONFIGPARAM|8i.ORACLE8.1.GENDIRECTORIES|8i.ORACLE8.1.CTLEXTENSION|.ctl|Y|null
CONFIGPARAM|8i.ORACLE8.1.GENDIRECTORIES|8i.ORACLE8.1.CTLRUNPRM|_run.ini|Y|null
CONFIGPARAM|8i.ORACLE8.1.RUNTIMEDIRECTORIES|8i.ORACLE8.1.RECEIVEDIRECTORY|receive\|Y|null
CONFIGPARAM|8i.ORACLE8.1.RUNTIMEDIRECTORIES|8i.ORACLE8.1.INPUTDIRECTORY|input\|Y|null
CONFIGPARAM|8i.ORACLE8.1.RUNTIMEDIRECTORIES|8i.ORACLE8.1.INVALIDDIRECTORY|invalid\|Y|null
CONFIGPARAM|8i.ORACLE8.1.RUNTIMEDIRECTORIES|8i.ORACLE8.1.WORKDIRECTORY|work\|Y|null
CONFIGPARAM|8i.ORACLE8.1.RUNTIMEDIRECTORIES|8i.ORACLE8.1.SORTDIRECTORY|sort\|Y|null
CONFIGPARAM|8i.ORACLE8.1.RUNTIMEDIRECTORIES|8i.ORACLE8.1.LOGDIRECTORY|log\|Y|null
CONFIGPARAM|8i.ORACLE8.1.RUNTIMEDIRECTORIES|8i.ORACLE8.1.ARCHIVEDIRECTORY|archive\|Y|null
CONFIGPARAM|8i.ORACLE8.1.GENPREFERENCES|8i.ORACLE8.1.GENPREFCRLF|\r\n|Y|null
CONFIGPARAM|8i.ORACLE8.1.GENPREFERENCES|8i.ORACLE8.1.DEPLOYMENTDBTYPE|Oracle9i|Y|null
CONFIGPARAM|8i.ORACLE8.1.DEFAULT_STORAGETABLESPACE|8i.ORACLE8.1.DEFAULT_INDEXTABLESPACE|null|Y|null
CONFIGPARAM|8i.ORACLE8.1.DEFAULT_STORAGETABLESPACE|8i.ORACLE8.1.DEFAULT_OBJECTTABLESPACE|null|Y|null
#
#Table <PhysicalName> <LogicalName> <UniversalID> <Imported> <Generated>
TABLE|PAY_DETAIL_STG|PAY_DETAIL_STG|F0B7BABAD80E4CDCE030A8C0FACA52BB|N|N
#Column <PhysicalName> <LogicalName> <UniversalID> <DataType> <Length> <Precision> <Scale> <Nullable> <DefaultValue> <Imported> <Generated> <Position>
COLUMN|EMPLOYEEID|EmployeeId|F0B7BABAD8324CDCE030A8C0FACA52BB|NUMBER|0|0|0|N|null|N|N|2
COLUMN|PAYROLLAMOUNT|PayrollAmount|F0B7BABAD8334CDCE030A8C0FACA52BB|NUMBER|0|0|0|N|null|N|N|3
COLUMN|PAYROLLID|PayrollId|F0B7BABAD8314CDCE030A8C0FACA52BB|NUMBER|0|0|0|N|null|N|N|1
#
#Table <PhysicalName> <LogicalName> <UniversalID> <Imported> <Generated>
TABLE|PAY_DATA_STG|PAY_DATA_STG|F0B5E976B7DC741CE030A8C0FACA4FFB|N|N
#Column <PhysicalName> <LogicalName> <UniversalID> <DataType> <Length> <Precision> <Scale> <Nullable> <DefaultValue> <Imported> <Generated> <Position>
COLUMN|DATE_FORMAT|OUTPUT1|F0B5E976B7FD741CE030A8C0FACA4FFB|DATE|0|0|0|N|null|N|N|2
COLUMN|PAYROLLID|PayrollID|F0B5E976B7FC741CE030A8C0FACA4FFB|NUMBER|0|0|0|N|null|N|N|1
#
#Sequence <PhysicalName> <LogicalName> <UniversalID> <Imported> <Generated>
SEQUENCE|TIME_DIM_SEQ|TIME_DIM_SEQ|F0B5E976B44C741CE030A8C0FACA4FFB|N|N
#Configuration Parameter  <GroupPhysicalName> <ParamPhysicalName> <ParamValue> <DefaultValue> <UniversalID>
CONFIGPARAM|8i.SEQUENCE.IDENTIFICATION|8i.SEQUENCE.DEPLOYABLE|true|Y|null
CONFIGPARAM|8i.SEQUENCE.SEQUENCEPARAMS|8i.SEQUENCE.INCREMENTBY|1|Y|null
CONFIGPARAM|8i.SEQUENCE.SEQUENCEPARAMS|8i.SEQUENCE.STARTWITH|1|Y|null
#
#Sequence <PhysicalName> <LogicalName> <UniversalID> <Imported> <Generated>
SEQUENCE|SALARY_DIM_SEQ|SALARY_DIM_SEQ|F0B5E976B44F741CE030A8C0FACA4FFB|N|N
#Configuration Parameter  <GroupPhysicalName> <ParamPhysicalName> <ParamValue> <DefaultValue> <UniversalID>
CONFIGPARAM|8i.SEQUENCE.IDENTIFICATION|8i.SEQUENCE.DEPLOYABLE|true|Y|null
CONFIGPARAM|8i.SEQUENCE.SEQUENCEPARAMS|8i.SEQUENCE.INCREMENTBY|1|Y|null
CONFIGPARAM|8i.SEQUENCE.SEQUENCEPARAMS|8i.SEQUENCE.STARTWITH|1|Y|null
#
#Sequence <PhysicalName> <LogicalName> <UniversalID> <Imported> <Generated>
SEQUENCE|EMPLOYEE_DIM_SEQ|EMPLOYEE_DIM_SEQ|F0B5E976B452741CE030A8C0FACA4FFB|N|N
#Configuration Parameter  <GroupPhysicalName> <ParamPhysicalName> <ParamValue> <DefaultValue> <UniversalID>
CONFIGPARAM|8i.SEQUENCE.IDENTIFICATION|8i.SEQUENCE.DEPLOYABLE|true|Y|null
CONFIGPARAM|8i.SEQUENCE.SEQUENCEPARAMS|8i.SEQUENCE.INCREMENTBY|1|Y|null
CONFIGPARAM|8i.SEQUENCE.SEQUENCEPARAMS|8i.SEQUENCE.STARTWITH|42|N|F0B5E976B456741CE030A8C0FACA4FFB
#
#Dimension <PhysicalName> <LogicalName> <UniversalID> <Prefix> <UsageType> <Imported> <Generated>
DIMENSION|TIME_DIM|TIME_DIM|F0B5E976B48C741CE030A8C0FACA4FFB|TIME_DIM|null|N|N
#
#Level <PhysicalName> <LogicalName> <UniversalID> <Prefix> <Imported> <Generated>
LEVEL|CAL_DATE_L|CAL_DATE_L|F0B5E976B49B741CE030A8C0FACA4FFB|null|N|N
#Level Attribute <PhysicalName> <LogicalName> <UniversalID> <DataType> <Length> <Precision> <Scale> <Nullable> <DefaultValue>
#     REFERENCEDITEM <ReferencedColumnPhysicalName> <ReferencedColumnLogicalName> <ReferencedColumnUniversalID>
#     <Imported> <Generated> <TypeCode>
COLUMN|ID|ID|F0B5E976B49E741CE030A8C0FACA4FFB|NUMBER|0|0|0|N|null|REFERENCEDITEM|CAL_DATE_L_ID|CAL_DATE_L ID|F0B5E976B49F741CE030A8C0FACA4FFB|N|Y|0
COLUMN|NAME|NAME|F0B5E976B4A9741CE030A8C0FACA4FFB|DATE|0|0|0|N|null|REFERENCEDITEM|CAL_DATE_L_NAME|CAL_DATE_L_NAME|F0B5E976B4AA741CE030A8C0FACA4FFB|N|N|0
#Level Unique Key <PhysicalName> <LogicalName> <UniversalID>
#     REFERENCEDITEM <ReferencedConstraintPhysicalName> <ReferencedConstraintLogicalName> <ReferencedConstraintUniversalID>
#     <Imported> <Generated> <TypeCode> <KeyColumnPhyName1> <KeyColumnUniversalID1> .. <KeyColumnPhyNameN> <KeyColumnUniversalIDN>
UNIQUEKEY|CAL_DATE_L_UK|CAL_DATE_L_UK|F0B5E976B49C741CE030A8C0FACA4FFB|REFERENCEDITEM|TIME_DIM_CAL_DATE_L_UK|TIME_DIM_CAL_DATE_L_UK|F0B5E976B49D741CE030A8C0FACA4FFB|N|Y|0|ID|F0B5E976B49E741CE030A8C0FACA4FFB
#
LEVEL|TOTAL_L|TOTAL_L|F0B5E976B4A2741CE030A8C0FACA4FFB|null|N|N
COLUMN|NAME|NAME|F0B5E976B4A5741CE030A8C0FACA4FFB|VARCHAR2|10|0|0|N|null|REFERENCEDITEM|TOTAL_L_NAME|TOTAL_L NAME|F0B5E976B4A6741CE030A8C0FACA4FFB|N|Y|0
UNIQUEKEY|TOTAL_L_UK|TOTAL_L_UK|F0B5E976B4A3741CE030A8C0FACA4FFB|REFERENCEDITEM|TIME_DIM_TOTAL_L_UK|TIME_DIM_TOTAL_L_UK|F0B5E976B4A4741CE030A8C0FACA4FFB|N|Y|0|NAME|F0B5E976B4A5741CE030A8C0FACA4FFB
#
LEVEL|CAL_YEAR_L|CAL_YEAR_L|F0B5E976B48D741CE030A8C0FACA4FFB|null|N|N
COLUMN|ID|ID|F0B5E976B490741CE030A8C0FACA4FFB|NUMBER|0|0|0|N|null|REFERENCEDITEM|CAL_YEAR_L_ID|CAL_YEAR_L ID|F0B5E976B491741CE030A8C0FACA4FFB|N|Y|0
UNIQUEKEY|CAL_YEAR_L_UK|CAL_YEAR_L_UK|F0B5E976B48E741CE030A8C0FACA4FFB|REFERENCEDITEM|TIME_DIM_CAL_YEAR_L_UK|TIME_DIM_CAL_YEAR_L_UK|F0B5E976B48F741CE030A8C0FACA4FFB|N|Y|0|ID|F0B5E976B490741CE030A8C0FACA4FFB
#
LEVEL|CAL_QTR_L|CAL_QTR_L|F0B5E976B494741CE030A8C0FACA4FFB|null|N|N
COLUMN|ID|ID|F0B5E976B497741CE030A8C0FACA4FFB|NUMBER|0|0|0|N|null|REFERENCEDITEM|CAL_QTR_L_ID|CAL_QTR_L ID|F0B5E976B498741CE030A8C0FACA4FFB|N|Y|0
UNIQUEKEY|CAL_QTR_L_UK|CAL_QTR_L_UK|F0B5E976B495741CE030A8C0FACA4FFB|REFERENCEDITEM|TIME_DIM_CAL_QTR_L_UK|TIME_DIM_CAL_QTR_L_UK|F0B5E976B496741CE030A8C0FACA4FFB|N|Y|0|ID|F0B5E976B497741CE030A8C0FACA4FFB
#
#Hierarchy <PhysicalName> <LogicalName> <UniversalID> <Prefix> <DefaultNamedAttributePhysicalName>
#     <DefaultNamedAttributeLogicalName> <DefaultNamedAttributeUniversalID> <Imported> <Generated>
HIERARCHY|CALENDARY_H|CALENDARY_H|F0B5E976B4AB741CE030A8C0FACA4FFB|TIME_DIM|CALENDARY_H|CALENDARY_H|F0B5E976B4AC741CE030A8C0FACA4FFB|N|N
#
#Level Relationship <PhysicalName> <LogicalName> <ParentLevelPhysicalName> <ParentLevelUniversalID>
#     <ChildLevelPhysicalName> <ChildLevelUniversalID> <Imported> <Generated>
LEVELRELATIONSHIP|null|null|TOTAL_L|F0B5E976B4A2741CE030A8C0FACA4FFB|CAL_YEAR_L|F0B5E976B48D741CE030A8C0FACA4FFB|N|N
LEVELRELATIONSHIP|null|null|CAL_YEAR_L|F0B5E976B48D741CE030A8C0FACA4FFB|CAL_QTR_L|F0B5E976B494741CE030A8C0FACA4FFB|N|N
LEVELRELATIONSHIP|null|null|null|null|TOTAL_L|F0B5E976B4A2741CE030A8C0FACA4FFB|N|N
LEVELRELATIONSHIP|null|null|CAL_QTR_L|F0B5E976B494741CE030A8C0FACA4FFB|CAL_DATE_L|F0B5E976B49B741CE030A8C0FACA4FFB|N|N
#
DIMENSION|TIME_DIM|TIME_DIM|F0B5E976B48C741CE030A8C0FACA4FFB|TIME_DIM|null|N|N
#Column <PhysicalName> <LogicalName> <UniversalID> <DataType> <Length> <Precision> <Scale> <Nullable> <DefaultValue> <Imported> <Generated> <Position>
COLUMN|CAL_DATE_L_ID|CAL_DATE_L ID|F0B5E976B49F741CE030A8C0FACA4FFB|NUMBER|0|0|0|N|null|N|Y|1
COLUMN|CAL_DATE_L_NAME|CAL_DATE_L_NAME|F0B5E976B4AA741CE030A8C0FACA4FFB|DATE|0|0|0|N|null|N|N|2
COLUMN|CAL_QTR_L_ID|CAL_QTR_L ID|F0B5E976B498741CE030A8C0FACA4FFB|NUMBER|0|0|0|N|null|N|Y|3
COLUMN|CAL_YEAR_L_ID|CAL_YEAR_L ID|F0B5E976B491741CE030A8C0FACA4FFB|NUMBER|0|0|0|N|null|N|Y|4
COLUMN|TOTAL_L_NAME|TOTAL_L NAME|F0B5E976B4A6741CE030A8C0FACA4FFB|VARCHAR2|10|0|0|N|null|N|Y|5
#
#Unique Key <PhysicalName> <LogicalName> <UniversalID> <Imported> <Generated> <KeyColumnPhyName1> <KeyColumnUniversalID1> .. <KeyColumnPhyNameN> <KeyColumnUniversalIDN>
UNIQUEKEY|TIME_DIM_CAL_DATE_L_UK|TIME_DIM_CAL_DATE_L_UK|F0B5E976B49D741CE030A8C0FACA4FFB|N|Y|CAL_DATE_L_ID|F0B5E976B49F741CE030A8C0FACA4FFB
UNIQUEKEY|TIME_DIM_TOTAL_L_UK|TIME_DIM_TOTAL_L_UK|F0B5E976B4A4741CE030A8C0FACA4FFB|N|Y|TOTAL_L_NAME|F0B5E976B4A6741CE030A8C0FACA4FFB
UNIQUEKEY|TIME_DIM_CAL_YEAR_L_UK|TIME_DIM_CAL_YEAR_L_UK|F0B5E976B48F741CE030A8C0FACA4FFB|N|Y|CAL_YEAR_L_ID|F0B5E976B491741CE030A8C0FACA4FFB
UNIQUEKEY|TIME_DIM_CAL_QTR_L_UK|TIME_DIM_CAL_QTR_L_UK|F0B5E976B496741CE030A8C0FACA4FFB|N|Y|CAL_QTR_L_ID|F0B5E976B498741CE030A8C0FACA4FFB
#
#Dimension <PhysicalName> <LogicalName> <UniversalID> <Prefix> <UsageType> <Imported> <Generated>
DIMENSION|EMPLOYEE_DIM|EMPLOYEE_DIM|F0B5E976B4E1741CE030A8C0FACA4FFB|EMPLOYEE_DIM|null|N|N
#
#Level <PhysicalName> <LogicalName> <UniversalID> <Prefix> <Imported> <Generated>
LEVEL|DEPARTMENT_L|DEPARTMENT_L|F0B5E976B4EB741CE030A8C0FACA4FFB|null|N|N
#Level Attribute <PhysicalName> <LogicalName> <UniversalID> <DataType> <Length> <Precision> <Scale> <Nullable> <DefaultValue>
#     REFERENCEDITEM <ReferencedColumnPhysicalName> <ReferencedColumnLogicalName> <ReferencedColumnUniversalID>
#     <Imported> <Generated> <TypeCode>
COLUMN|NAME|NAME|F0B5E976B4EE741CE030A8C0FACA4FFB|VARCHAR2|40|0|0|N|null|REFERENCEDITEM|DEPARTMENT_L_NAME|DEPARTMENT_L NAME|F0B5E976B4EF741CE030A8C0FACA4FFB|N|Y|0
#Level Unique Key <PhysicalName> <LogicalName> <UniversalID>
#     REFERENCEDITEM <ReferencedConstraintPhysicalName> <ReferencedConstraintLogicalName> <ReferencedConstraintUniversalID>
#     <Imported> <Generated> <TypeCode> <KeyColumnPhyName1> <KeyColumnUniversalID1> .. <KeyColumnPhyNameN> <KeyColumnUniversalIDN>
UNIQUEKEY|DEPARTMENT_L_UK|DEPARTMENT_L_UK|F0B5E976B4EC741CE030A8C0FACA4FFB|REFERENCEDITEM|EMPLOYEE_DEPARTMENT_L_UK|EMPLOYEE_DEPARTMENT_L_UK|F0B5E976B4ED741CE030A8C0FACA4FFB|N|Y|0|NAME|F0B5E976B4EE741CE030A8C0FACA4FFB
#
LEVEL|TOTAL_L|TOTAL_L|F0B5E976B4E2741CE030A8C0FACA4FFB|null|N|N
COLUMN|NAME|NAME|F0B5E976B4E7741CE030A8C0FACA4FFB|VARCHAR2|10|0|0|N|null|REFERENCEDITEM|TOTAL_L_NAME|TOTAL_L NAME|F0B5E976B4E8741CE030A8C0FACA4FFB|N|Y|0
UNIQUEKEY|TOTAL_L_UK_2|TOTAL_L_UK_2|F0B5E976B4E5741CE030A8C0FACA4FFB|REFERENCEDITEM|EMPLOYEE_TOTAL_L_UK|EMPLOYEE_TOTAL_L_UK|F0B5E976B4E6741CE030A8C0FACA4FFB|N|Y|0|NAME|F0B5E976B4E7741CE030A8C0FACA4FFB
#
LEVEL|EMPLOYEE_L|EMPLOYEE_L|F0B5E976B4F2741CE030A8C0FACA4FFB|null|N|N
COLUMN|ID|ID|F0B5E976B4F5741CE030A8C0FACA4FFB|NUMBER|40|0|0|N|null|REFERENCEDITEM|EMPLOYEE_L_ID|EMPLOYEE_L ID|F0B5E976B4F6741CE030A8C0FACA4FFB|N|Y|0
COLUMN|NAME|NAME|F0B5E976B4F9741CE030A8C0FACA4FFB|VARCHAR2|40|0|0|N|null|REFERENCEDITEM|EMPLOYEE_L_NAME|EMPLOYEE_L_NAME|F0B5E976B4FA741CE030A8C0FACA4FFB|N|N|0
UNIQUEKEY|EMPLOYEE_L_UK|EMPLOYEE_L_UK|F0B5E976B4F3741CE030A8C0FACA4FFB|REFERENCEDITEM|EMPLOYEE_EMPLOYEE_L_UK|EMPLOYEE_EMPLOYEE_L_UK|F0B5E976B4F4741CE030A8C0FACA4FFB|N|Y|0|ID|F0B5E976B4F5741CE030A8C0FACA4FFB
#
#Hierarchy <PhysicalName> <LogicalName> <UniversalID> <Prefix> <DefaultNamedAttributePhysicalName>
#     <DefaultNamedAttributeLogicalName> <DefaultNamedAttributeUniversalID> <Imported> <Generated>
HIERARCHY|DEPARTMENTAL_H|DEPARTMENTAL_H|F0B5E976B4FB741CE030A8C0FACA4FFB|EMPLOYEE_DIM|DEPARTMENTAL_H|DEPARTMENTAL_H|F0B5E976B4FC741CE030A8C0FACA4FFB|N|N
#
#Level Relationship <PhysicalName> <LogicalName> <ParentLevelPhysicalName> <ParentLevelUniversalID>
#     <ChildLevelPhysicalName> <ChildLevelUniversalID> <Imported> <Generated>
LEVELRELATIONSHIP|null|null|null|null|TOTAL_L|F0B5E976B4E2741CE030A8C0FACA4FFB|N|N
LEVELRELATIONSHIP|null|null|DEPARTMENT_L|F0B5E976B4EB741CE030A8C0FACA4FFB|EMPLOYEE_L|F0B5E976B4F2741CE030A8C0FACA4FFB|N|N
LEVELRELATIONSHIP|null|null|TOTAL_L|F0B5E976B4E2741CE030A8C0FACA4FFB|DEPARTMENT_L|F0B5E976B4EB741CE030A8C0FACA4FFB|N|N
#
DIMENSION|EMPLOYEE_DIM|EMPLOYEE_DIM|F0B5E976B4E1741CE030A8C0FACA4FFB|EMPLOYEE_DIM|null|N|N
#Column <PhysicalName> <LogicalName> <UniversalID> <DataType> <Length> <Precision> <Scale> <Nullable> <DefaultValue> <Imported> <Generated> <Position>
COLUMN|DEPARTMENT_L_NAME|DEPARTMENT_L NAME|F0B5E976B4EF741CE030A8C0FACA4FFB|VARCHAR2|40|0|0|N|null|N|Y|1
COLUMN|EMPLOYEE_L_ID|EMPLOYEE_L ID|F0B5E976B4F6741CE030A8C0FACA4FFB|NUMBER|40|0|0|N|null|N|Y|2
COLUMN|EMPLOYEE_L_NAME|EMPLOYEE_L_NAME|F0B5E976B4FA741CE030A8C0FACA4FFB|VARCHAR2|40|0|0|N|null|N|N|3
COLUMN|TOTAL_L_NAME|TOTAL_L NAME|F0B5E976B4E8741CE030A8C0FACA4FFB|VARCHAR2|10|0|0|N|null|N|Y|4
#
#Unique Key <PhysicalName> <LogicalName> <UniversalID> <Imported> <Generated> <KeyColumnPhyName1> <KeyColumnUniversalID1> .. <KeyColumnPhyNameN> <KeyColumnUniversalIDN>
UNIQUEKEY|EMPLOYEE_DEPARTMENT_L_UK|EMPLOYEE_DEPARTMENT_L_UK|F0B5E976B4ED741CE030A8C0FACA4FFB|N|Y|DEPARTMENT_L_NAME|F0B5E976B4EF741CE030A8C0FACA4FFB
UNIQUEKEY|EMPLOYEE_TOTAL_L_UK|EMPLOYEE_TOTAL_L_UK|F0B5E976B4E6741CE030A8C0FACA4FFB|N|Y|TOTAL_L_NAME|F0B5E976B4E8741CE030A8C0FACA4FFB
UNIQUEKEY|EMPLOYEE_EMPLOYEE_L_UK|EMPLOYEE_EMPLOYEE_L_UK|F0B5E976B4F4741CE030A8C0FACA4FFB|N|Y|EMPLOYEE_L_ID|F0B5E976B4F6741CE030A8C0FACA4FFB
#
#Dimension <PhysicalName> <LogicalName> <UniversalID> <Prefix> <UsageType> <Imported> <Generated>
DIMENSION|SALARY_DIM|SALARY_DIM|F0B5E976B4BC741CE030A8C0FACA4FFB|SALARY_DIM|null|N|N
#
#Level <PhysicalName> <LogicalName> <UniversalID> <Prefix> <Imported> <Generated>
LEVEL|SAL_GRADE_L|SAL_GRADE_L|F0B5E976B4CC741CE030A8C0FACA4FFB|null|N|N
#Level Attribute <PhysicalName> <LogicalName> <UniversalID> <DataType> <Length> <Precision> <Scale> <Nullable> <DefaultValue>
#     REFERENCEDITEM <ReferencedColumnPhysicalName> <ReferencedColumnLogicalName> <ReferencedColumnUniversalID>
#     <Imported> <Generated> <TypeCode>
COLUMN|ID|ID|F0B5E976B4CF741CE030A8C0FACA4FFB|NUMBER|0|0|0|N|null|REFERENCEDITEM|SAL_GRADE_L_ID|SAL_GRADE_L ID|F0B5E976B4D0741CE030A8C0FACA4FFB|N|Y|0
COLUMN|SALGRADE|SALGRADE|F0B5E976B4D3741CE030A8C0FACA4FFB|NUMBER|0|0|0|N|null|REFERENCEDITEM|SAL_GRADE_L_SALGRADE|SAL_GRADE_L_SALGRADE|F0B5E976B4D4741CE030A8C0FACA4FFB|N|N|0
#Level Unique Key <PhysicalName> <LogicalName> <UniversalID>
#     REFERENCEDITEM <ReferencedConstraintPhysicalName> <ReferencedConstraintLogicalName> <ReferencedConstraintUniversalID>
#     <Imported> <Generated> <TypeCode> <KeyColumnPhyName1> <KeyColumnUniversalID1> .. <KeyColumnPhyNameN> <KeyColumnUniversalIDN>
UNIQUEKEY|SAL_GRADE_L_UK|SAL_GRADE_L_UK|F0B5E976B4CD741CE030A8C0FACA4FFB|REFERENCEDITEM|SALARY_D_SAL_GRADE_L_UK|SALARY_D_SAL_GRADE_L_UK|F0B5E976B4CE741CE030A8C0FACA4FFB|N|Y|0|ID|F0B5E976B4CF741CE030A8C0FACA4FFB
#
LEVEL|TOTAL_L|TOTAL_L|F0B5E976B4BD741CE030A8C0FACA4FFB|null|N|N
COLUMN|NAME|NAME|F0B5E976B4C1741CE030A8C0FACA4FFB|VARCHAR2|10|0|0|N|null|REFERENCEDITEM|TOTAL_L_NAME|TOTAL_L NAME|F0B5E976B4C2741CE030A8C0FACA4FFB|N|Y|0
UNIQUEKEY|TOTAL_L_UK_1|TOTAL_L_UK_1|F0B5E976B4BF741CE030A8C0FACA4FFB|REFERENCEDITEM|SALARY_D_TOTAL_L_UK|SALARY_D_TOTAL_L_UK|F0B5E976B4C0741CE030A8C0FACA4FFB|N|Y|0|NAME|F0B5E976B4C1741CE030A8C0FACA4FFB
#
LEVEL|SAL_CAT_L|SAL_CAT_L|F0B5E976B4C5741CE030A8C0FACA4FFB|null|N|N
COLUMN|NAME|NAME|F0B5E976B4C8741CE030A8C0FACA4FFB|VARCHAR2|10|0|0|N|null|REFERENCEDITEM|SAL_CAT_L_NAME|SAL_CAT_L NAME|F0B5E976B4C9741CE030A8C0FACA4FFB|N|Y|0
UNIQUEKEY|SAL_CAT_L_UK|SAL_CAT_L_UK|F0B5E976B4C6741CE030A8C0FACA4FFB|REFERENCEDITEM|SALARY_D_SAL_CAT_L_UK|SALARY_D_SAL_CAT_L_UK|F0B5E976B4C7741CE030A8C0FACA4FFB|N|Y|0|NAME|F0B5E976B4C8741CE030A8C0FACA4FFB
#
#Hierarchy <PhysicalName> <LogicalName> <UniversalID> <Prefix> <DefaultNamedAttributePhysicalName>
#     <DefaultNamedAttributeLogicalName> <DefaultNamedAttributeUniversalID> <Imported> <Generated>
HIERARCHY|GRADED_H|GRADED_H|F0B5E976B4D5741CE030A8C0FACA4FFB|SALARY_DIM|GRADED_H|GRADED_H|F0B5E976B4D6741CE030A8C0FACA4FFB|N|N
#
#Level Relationship <PhysicalName> <LogicalName> <ParentLevelPhysicalName> <ParentLevelUniversalID>
#     <ChildLevelPhysicalName> <ChildLevelUniversalID> <Imported> <Generated>
LEVELRELATIONSHIP|null|null|null|null|TOTAL_L|F0B5E976B4BD741CE030A8C0FACA4FFB|N|N
LEVELRELATIONSHIP|null|null|TOTAL_L|F0B5E976B4BD741CE030A8C0FACA4FFB|SAL_CAT_L|F0B5E976B4C5741CE030A8C0FACA4FFB|N|N
LEVELRELATIONSHIP|null|null|SAL_CAT_L|F0B5E976B4C5741CE030A8C0FACA4FFB|SAL_GRADE_L|F0B5E976B4CC741CE030A8C0FACA4FFB|N|N
#
DIMENSION|SALARY_DIM|SALARY_DIM|F0B5E976B4BC741CE030A8C0FACA4FFB|SALARY_DIM|null|N|N
#Column <PhysicalName> <LogicalName> <UniversalID> <DataType> <Length> <Precision> <Scale> <Nullable> <DefaultValue> <Imported> <Generated> <Position>
COLUMN|SAL_CAT_L_NAME|SAL_CAT_L NAME|F0B5E976B4C9741CE030A8C0FACA4FFB|VARCHAR2|10|0|0|N|null|N|Y|1
COLUMN|SAL_GRADE_L_ID|SAL_GRADE_L ID|F0B5E976B4D0741CE030A8C0FACA4FFB|NUMBER|0|0|0|N|null|N|Y|2
COLUMN|SAL_GRADE_L_SALGRADE|SAL_GRADE_L_SALGRADE|F0B5E976B4D4741CE030A8C0FACA4FFB|NUMBER|0|0|0|N|null|N|N|3
COLUMN|TOTAL_L_NAME|TOTAL_L NAME|F0B5E976B4C2741CE030A8C0FACA4FFB|VARCHAR2|10|0|0|N|null|N|Y|4
#
#Unique Key <PhysicalName> <LogicalName> <UniversalID> <Imported> <Generated> <KeyColumnPhyName1> <KeyColumnUniversalID1> .. <KeyColumnPhyNameN> <KeyColumnUniversalIDN>
UNIQUEKEY|SALARY_D_SAL_GRADE_L_UK|SALARY_D_SAL_GRADE_L_UK|F0B5E976B4CE741CE030A8C0FACA4FFB|N|Y|SAL_GRADE_L_ID|F0B5E976B4D0741CE030A8C0FACA4FFB
UNIQUEKEY|SALARY_D_TOTAL_L_UK|SALARY_D_TOTAL_L_UK|F0B5E976B4C0741CE030A8C0FACA4FFB|N|Y|TOTAL_L_NAME|F0B5E976B4C2741CE030A8C0FACA4FFB
UNIQUEKEY|SALARY_D_SAL_CAT_L_UK|SALARY_D_SAL_CAT_L_UK|F0B5E976B4C7741CE030A8C0FACA4FFB|N|Y|SAL_CAT_L_NAME|F0B5E976B4C9741CE030A8C0FACA4FFB
#
#Fact <PhysicalName> <LogicalName> <UniversalID> <SegmentedKeyFlag> <Imported> <Generated>
FACT|PAYROLL_EXPENDITURES_CUBE|PAYROLL_EXPENDITURES_CUBE|F0B5E976B564741CE030A8C0FACA4FFB|N|N|N
#Measure <PhysicalName> <LogicalName> <UniversalID> <DataType> <Length> <Precision> <Scale> <Nullable> <DefaultValue> <Imported> <Generated> <Position>
MEASURE|AMOUNT|AMOUNT|F0B5E976B56E741CE030A8C0FACA4FFB|NUMBER|0|0|0|N|null|N|N|null
#
#Oracle Installed Module  <PhysicalName> <LogicalName> <UniversalID> <Typecode> <Logical> <CanBeSource> <CanBeHub> <CanBeWarehouse>
#     <Status> <System> <SystemType(SoftwareModuleVersion)> <Integrator> <ApplicationType>
#     <DatabaseLink> <MetadataImported> <ImportTable> <ImportView> <ImportSynonym>
#     <Schema> <NameFilter> <ApplyFilter> <MetadataDBLink> <ImportSequence> <LocationName> <LocationUniversalID>
ORACLEINSTALLEDMODULE|SCOTT|SCOTT|F0B5E976B595741CE030A8C0FACA4FFB|DATABASE_DICTIONARY.|null|Y|N|N|DEV_STATUS|null|Oracle Database 8i/9i/10g|Oracle OWB Integrator for Oracle DB and Apps 3.0|Generic Oracle Database Application|SCOTT_LINK.BAYONTECHNOLOGIES.COM|null|Y|Y|Y|SCOTT|null|N|null|Y|SCOTT_L|F0B5E976B596741CE030A8C0FACA4FFB
#
#Table <PhysicalName> <LogicalName> <UniversalID> <Imported> <Generated>
TABLE|DEPT|DEPT|F0B5E976B597741CE030A8C0FACA4FFB|Y|N
#Column <PhysicalName> <LogicalName> <UniversalID> <DataType> <Length> <Precision> <Scale> <Nullable> <DefaultValue> <Imported> <Generated> <Position>
COLUMN|DEPTNO|DEPTNO|F0B5E976B598741CE030A8C0FACA4FFB|NUMBER|0|2|0|Y|null|Y|N|1
COLUMN|DNAME|DNAME|F0B5E976B599741CE030A8C0FACA4FFB|VARCHAR2|14|0|0|N|null|Y|N|2
COLUMN|LOC|LOC|F0B5E976B59A741CE030A8C0FACA4FFB|VARCHAR2|13|0|0|N|null|Y|N|3
#
#Primary Key <PhysicalName> <LogicalName> <UniversalID> <Imported> <Generated> <KeyColumnPhyName1> <KeyColumnUniversalID1> .. <KeyColumnPhyNameN> <KeyColumnUniversalIDN>
PRIMARYKEY|PK_DEPT|PK_DEPT|F0B5E976B59B741CE030A8C0FACA4FFB|Y|N|DEPTNO|F0B5E976B598741CE030A8C0FACA4FFB
#
#Table <PhysicalName> <LogicalName> <UniversalID> <Imported> <Generated>
TABLE|SALGRADE|SALGRADE|F0B5E976B5AA741CE030A8C0FACA4FFB|Y|N
#Column <PhysicalName> <LogicalName> <UniversalID> <DataType> <Length> <Precision> <Scale> <Nullable> <DefaultValue> <Imported> <Generated> <Position>
COLUMN|GRADE|GRADE|F0B5E976B5AB741CE030A8C0FACA4FFB|NUMBER|0|0|0|N|null|Y|N|1
COLUMN|HISAL|HISAL|F0B5E976B5AD741CE030A8C0FACA4FFB|NUMBER|0|0|0|N|null|Y|N|3
COLUMN|LOSAL|LOSAL|F0B5E976B5AC741CE030A8C0FACA4FFB|NUMBER|0|0|0|N|null|Y|N|2
#
#Table <PhysicalName> <LogicalName> <UniversalID> <Imported> <Generated>
TABLE|EMP|EMP|F0B5E976B59D741CE030A8C0FACA4FFB|Y|N
#Column <PhysicalName> <LogicalName> <UniversalID> <DataType> <Length> <Precision> <Scale> <Nullable> <DefaultValue> <Imported> <Generated> <Position>
COLUMN|COMM|COMM|F0B5E976B5A4741CE030A8C0FACA4FFB|NUMBER|0|7|2|N|null|Y|N|7
COLUMN|DEPTNO|DEPTNO|F0B5E976B5A5741CE030A8C0FACA4FFB|NUMBER|0|2|0|N|null|Y|N|8
COLUMN|EMPNO|EMPNO|F0B5E976B59E741CE030A8C0FACA4FFB|NUMBER|0|4|0|Y|null|Y|N|1
COLUMN|ENAME|ENAME|F0B5E976B59F741CE030A8C0FACA4FFB|VARCHAR2|10|0|0|N|null|Y|N|2
COLUMN|HIREDATE|HIREDATE|F0B5E976B5A2741CE030A8C0FACA4FFB|DATE|0|0|0|N|null|Y|N|5
COLUMN|JOB|JOB|F0B5E976B5A0741CE030A8C0FACA4FFB|VARCHAR2|9|0|0|N|null|Y|N|3
COLUMN|MGR|MGR|F0B5E976B5A1741CE030A8C0FACA4FFB|NUMBER|0|4|0|N|null|Y|N|4
COLUMN|SAL|SAL|F0B5E976B5A3741CE030A8C0FACA4FFB|NUMBER|0|7|2|N|null|Y|N|6
#
#Primary Key <PhysicalName> <LogicalName> <UniversalID> <Imported> <Generated> <KeyColumnPhyName1> <KeyColumnUniversalID1> .. <KeyColumnPhyNameN> <KeyColumnUniversalIDN>
PRIMARYKEY|PK_EMP|PK_EMP|F0B5E976B5A6741CE030A8C0FACA4FFB|Y|N|EMPNO|F0B5E976B59E741CE030A8C0FACA4FFB
#
DATAWAREHOUSE|OWB_TST|OWB_TST|F0B5E976B44A741CE030A8C0FACA4FFB
FACT|PAYROLL_EXPENDITURES_CUBE|PAYROLL_EXPENDITURES_CUBE|F0B5E976B564741CE030A8C0FACA4FFB|N|N|N
#Fact Foreign Key <PhysicalName> <LogicalName> <UniversalID> <Imported> <Generated>
#     <ReferencedModulePhyName> <ReferencedModuleLogName> <ReferencedModuleUniversalID>
#     <ReferencedDimensionPhyName> <ReferencedDimensionLogName> <ReferencedDimensionUniversalID>
#     <ReferencedConstraintPhyName> <ReferencedConstraintLogName> <ReferencedConstraintUniversalID>
#     RENAMED <KeyColumnPhyName1> <KeyColumnLogName1> <KeyColumnUniversalID1> .. <KeyColumnPhyNameN> <KeyColumnLogName1> <KeyColumnUniversalIDN>
FACTFOREIGNKEY|FK_PAYROLL_EXPENDITURES_10588|FK_PAYROLL_EXPENDITURES_10588|F0B5E976B565741CE030A8C0FACA4FFB|N|Y|OWB_TST|OWB_TST|F0B5E976B44A741CE030A8C0FACA4FFB|TIME_DIM|TIME_DIM|F0B5E976B48C741CE030A8C0FACA4FFB|TIME_DIM_CAL_DATE_L_UK|TIME_DIM_CAL_DATE_L_UK|F0B5E976B49D741CE030A8C0FACA4FFB|RENAMED|CAL_DATE_L_ID|CAL_DATE_L_ID|F0B5E976B566741CE030A8C0FACA4FFB
FACTFOREIGNKEYCOLUMN|CAL_DATE_L_ID|CAL_DATE_L_ID|F0B5E976B566741CE030A8C0FACA4FFB|NUMBER|0|0|0|N|null|N|Y|null
#
FACTFOREIGNKEY|FK_PAYROLL_EXPENDITURES_10637|FK_PAYROLL_EXPENDITURES_10637|F0B5E976B568741CE030A8C0FACA4FFB|N|Y|OWB_TST|OWB_TST|F0B5E976B44A741CE030A8C0FACA4FFB|SALARY_DIM|SALARY_DIM|F0B5E976B4BC741CE030A8C0FACA4FFB|SALARY_D_SAL_GRADE_L_UK|SALARY_D_SAL_GRADE_L_UK|F0B5E976B4CE741CE030A8C0FACA4FFB|RENAMED|SAL_GRADE_L_ID|SAL_GRADE_L_ID|F0B5E976B569741CE030A8C0FACA4FFB
FACTFOREIGNKEYCOLUMN|SAL_GRADE_L_ID|SAL_GRADE_L_ID|F0B5E976B569741CE030A8C0FACA4FFB|NUMBER|0|0|0|N|null|N|Y|null
#
FACTFOREIGNKEY|FK_PAYROLL_EXPENDITURES_10675|FK_PAYROLL_EXPENDITURES_10675|F0B5E976B56B741CE030A8C0FACA4FFB|N|Y|OWB_TST|OWB_TST|F0B5E976B44A741CE030A8C0FACA4FFB|EMPLOYEE_DIM|EMPLOYEE_DIM|F0B5E976B4E1741CE030A8C0FACA4FFB|EMPLOYEE_EMPLOYEE_L_UK|EMPLOYEE_EMPLOYEE_L_UK|F0B5E976B4F4741CE030A8C0FACA4FFB|RENAMED|EMPLOYEE_L_ID|EMPLOYEE_L_ID|F0B5E976B56C741CE030A8C0FACA4FFB
FACTFOREIGNKEYCOLUMN|EMPLOYEE_L_ID|EMPLOYEE_L_ID|F0B5E976B56C741CE030A8C0FACA4FFB|NUMBER|0|0|0|N|null|N|Y|null
#
#
DATAWAREHOUSE|OWB_TST|OWB_TST|F0B5E976B44A741CE030A8C0FACA4FFB
#
ORACLEINSTALLEDMODULE|SCOTT|SCOTT|F0B5E976B595741CE030A8C0FACA4FFB
TABLE|EMP|EMP|F0B5E976B59D741CE030A8C0FACA4FFB|null|null
#Foreign Key <PhysicalName> <LogicalName> <UniversalID> <Imported> <Generated>
#     <KeyColumnPhyName1> <KeyColumnUniversalID1> .. <KeyColumnPhyNameN> <KeyColumnUniversalIDN>
#     <UNIQUEKEY> <ReferencedModulePhyName> <ReferencedModuleLogName> <ReferencedModuleUniversalID>
#     <ReferencedEntityPhyName> <ReferencedEntityLogName> <ReferencedEntityUniversalID> <ReferencedEntityType>
#     <ReferencedConstraintPhyName> <ReferencedConstraintLogName> <ReferencedConstraintUniversalID>
FOREIGNKEY|FK_DEPTNO|FK_DEPTNO|F0B5E976B5A8741CE030A8C0FACA4FFB|Y|N|DEPTNO|F0B5E976B5A5741CE030A8C0FACA4FFB|UNIQUEKEY|SCOTT|SCOTT|F0B5E976B595741CE030A8C0FACA4FFB|DEPT|DEPT|F0B5E976B597741CE030A8C0FACA4FFB|TABLE|PK_DEPT|PK_DEPT|F0B5E976B59B741CE030A8C0FACA4FFB
#
DATAWAREHOUSE|OWB_TST|OWB_TST|F0B5E976B44A741CE030A8C0FACA4FFB
#
CONFIGURABLE|PAY_DETAIL_STG|PAY_DETAIL_STG|F0B7BABAD80E4CDCE030A8C0FACA52BB|TABLE
#Configuration Parameter  <GroupPhysicalName> <ParamPhysicalName> <ParamValue> <DefaultValue> <UniversalID>
CONFIGPARAM|8i.TABLES.PARTITIONING|8i.TABLES.HSPNUMBER|2|Y|null
CONFIGPARAM|8i.TABLES.PARTITIONING|8i.TABLES.STOREIN|null|Y|null
CONFIGPARAM|8i.TABLES.IDENTIFICATION|8i.TABLES.DEPLOYABLE|true|Y|null
CONFIGPARAM|8i.TABLES.STORAGESPACE|8i.TABLES.TABLESPACE|null|Y|null
CONFIGPARAM|8i.TABLES.PARALLELISM|8i.TABLES.PARALLEL|PARALLEL|Y|null
CONFIGPARAM|8i.TABLES.PERFORMANCEPARAM|8i.TABLES.LOGGING|LOGGING|Y|null
CONFIGPARAM|8i.TABLES.PERFORMANCEPARAM|8i.TABLES.ESTIMATEPCT|99|Y|null
#
CONFIGURABLE|PAY_DATA_STG|PAY_DATA_STG|F0B5E976B7DC741CE030A8C0FACA4FFB|TABLE
#Configuration Parameter  <GroupPhysicalName> <ParamPhysicalName> <ParamValue> <DefaultValue> <UniversalID>
CONFIGPARAM|8i.TABLES.PARTITIONING|8i.TABLES.HSPNUMBER|2|Y|null
CONFIGPARAM|8i.TABLES.PARTITIONING|8i.TABLES.STOREIN|null|Y|null
CONFIGPARAM|8i.TABLES.IDENTIFICATION|8i.TABLES.DEPLOYABLE|true|Y|null
CONFIGPARAM|8i.TABLES.STORAGESPACE|8i.TABLES.TABLESPACE|null|Y|null
CONFIGPARAM|8i.TABLES.PARALLELISM|8i.TABLES.PARALLEL|PARALLEL|Y|null
CONFIGPARAM|8i.TABLES.PERFORMANCEPARAM|8i.TABLES.LOGGING|LOGGING|Y|null
CONFIGPARAM|8i.TABLES.PERFORMANCEPARAM|8i.TABLES.ESTIMATEPCT|99|Y|null
#
CONFIGURABLE|TIME_DIM|TIME_DIM|F0B5E976B48C741CE030A8C0FACA4FFB|DIMENSION
#Configuration Parameter  <GroupPhysicalName> <ParamPhysicalName> <ParamValue> <DefaultValue> <UniversalID>
CONFIGPARAM|8i.DIMENSIONS.PARTITIONING|8i.DIMENSIONS.HSPNUMBER|2|Y|null
CONFIGPARAM|8i.DIMENSIONS.PARTITIONING|8i.DIMENSIONS.STOREIN|null|Y|null
CONFIGPARAM|8i.DIMENSIONS.IDENTIFICATION|8i.DIMENSIONS.DEPLOYABLE|true|Y|null
CONFIGPARAM|8i.DIMENSIONS.DIMGENOPTIONS|8i.DIMENSIONS.GENERATETABLE|true|Y|null
CONFIGPARAM|8i.DIMENSIONS.DIMGENOPTIONS|8i.DIMENSIONS.GENERATEDIMENSION|true|Y|null
CONFIGPARAM|8i.DIMENSIONS.STORAGESPACE|8i.DIMENSIONS.TABLESPACE|null|Y|null
CONFIGPARAM|8i.DIMENSIONS.PARALLELISM|8i.DIMENSIONS.PARALLEL|PARALLEL|Y|null
CONFIGPARAM|8i.DIMENSIONS.PERFORMANCEPARAM|8i.DIMENSIONS.LOGGING|LOGGING|Y|null
CONFIGPARAM|8i.DIMENSIONS.PERFORMANCEPARAM|8i.DIMENSIONS.ESTIMATEPCT|99|Y|null
#
#Child Configuration  <ConfigTreePhysicalName> <ChildPhysicalName> <ChildLogicalName> <ChildUniversalID> <RefConfigurableUniversalID>
CHILDCONFIG|8i.DIM.CONSTRAINT|TIME_DIM_CAL_DATE_L_UK|TIME_DIM_CAL_DATE_L_UK|null|F0B5E976B49D741CE030A8C0FACA4FFB
CONFIGPARAM|8i.DIM.CONSTRAINT.CREATIONMETHOD|8i.DIM.CONSTRAINT.USINGINDEX|false|Y|null
CONFIGPARAM|8i.DIM.CONSTRAINT.IDENTIFICATION|8i.DIM.CONSTRAINT.DEPLOYABLE|true|Y|null
#
CONFIGURABLE|EMPLOYEE_DIM|EMPLOYEE_DIM|F0B5E976B4E1741CE030A8C0FACA4FFB|DIMENSION
#Configuration Parameter  <GroupPhysicalName> <ParamPhysicalName> <ParamValue> <DefaultValue> <UniversalID>
CONFIGPARAM|8i.DIMENSIONS.PARTITIONING|8i.DIMENSIONS.HSPNUMBER|2|Y|null
CONFIGPARAM|8i.DIMENSIONS.PARTITIONING|8i.DIMENSIONS.STOREIN|null|Y|null
CONFIGPARAM|8i.DIMENSIONS.IDENTIFICATION|8i.DIMENSIONS.DEPLOYABLE|true|Y|null
CONFIGPARAM|8i.DIMENSIONS.DIMGENOPTIONS|8i.DIMENSIONS.GENERATETABLE|true|Y|null
CONFIGPARAM|8i.DIMENSIONS.DIMGENOPTIONS|8i.DIMENSIONS.GENERATEDIMENSION|true|Y|null
CONFIGPARAM|8i.DIMENSIONS.STORAGESPACE|8i.DIMENSIONS.TABLESPACE|null|Y|null
CONFIGPARAM|8i.DIMENSIONS.PARALLELISM|8i.DIMENSIONS.PARALLEL|PARALLEL|Y|null
CONFIGPARAM|8i.DIMENSIONS.PERFORMANCEPARAM|8i.DIMENSIONS.LOGGING|LOGGING|Y|null
CONFIGPARAM|8i.DIMENSIONS.PERFORMANCEPARAM|8i.DIMENSIONS.ESTIMATEPCT|99|Y|null
#
#Child Configuration  <ConfigTreePhysicalName> <ChildPhysicalName> <ChildLogicalName> <ChildUniversalID> <RefConfigurableUniversalID>
CHILDCONFIG|8i.DIM.CONSTRAINT|EMPLOYEE_EMPLOYEE_L_UK|EMPLOYEE_EMPLOYEE_L_UK|null|F0B5E976B4F4741CE030A8C0FACA4FFB
CONFIGPARAM|8i.DIM.CONSTRAINT.CREATIONMETHOD|8i.DIM.CONSTRAINT.USINGINDEX|false|Y|null
CONFIGPARAM|8i.DIM.CONSTRAINT.IDENTIFICATION|8i.DIM.CONSTRAINT.DEPLOYABLE|true|Y|null
#
CONFIGURABLE|SALARY_DIM|SALARY_DIM|F0B5E976B4BC741CE030A8C0FACA4FFB|DIMENSION
#Configuration Parameter  <GroupPhysicalName> <ParamPhysicalName> <ParamValue> <DefaultValue> <UniversalID>
CONFIGPARAM|8i.DIMENSIONS.PARTITIONING|8i.DIMENSIONS.HSPNUMBER|2|Y|null
CONFIGPARAM|8i.DIMENSIONS.PARTITIONING|8i.DIMENSIONS.STOREIN|null|Y|null
CONFIGPARAM|8i.DIMENSIONS.IDENTIFICATION|8i.DIMENSIONS.DEPLOYABLE|true|Y|null
CONFIGPARAM|8i.DIMENSIONS.DIMGENOPTIONS|8i.DIMENSIONS.GENERATETABLE|true|Y|null
CONFIGPARAM|8i.DIMENSIONS.DIMGENOPTIONS|8i.DIMENSIONS.GENERATEDIMENSION|true|Y|null
CONFIGPARAM|8i.DIMENSIONS.STORAGESPACE|8i.DIMENSIONS.TABLESPACE|null|Y|null
CONFIGPARAM|8i.DIMENSIONS.PARALLELISM|8i.DIMENSIONS.PARALLEL|PARALLEL|Y|null
CONFIGPARAM|8i.DIMENSIONS.PERFORMANCEPARAM|8i.DIMENSIONS.LOGGING|LOGGING|Y|null
CONFIGPARAM|8i.DIMENSIONS.PERFORMANCEPARAM|8i.DIMENSIONS.ESTIMATEPCT|99|Y|null
#
#Child Configuration  <ConfigTreePhysicalName> <ChildPhysicalName> <ChildLogicalName> <ChildUniversalID> <RefConfigurableUniversalID>
CHILDCONFIG|8i.DIM.CONSTRAINT|SALARY_D_SAL_GRADE_L_UK|SALARY_D_SAL_GRADE_L_UK|null|F0B5E976B4CE741CE030A8C0FACA4FFB
CONFIGPARAM|8i.DIM.CONSTRAINT.CREATIONMETHOD|8i.DIM.CONSTRAINT.USINGINDEX|false|Y|null
CONFIGPARAM|8i.DIM.CONSTRAINT.IDENTIFICATION|8i.DIM.CONSTRAINT.DEPLOYABLE|true|Y|null
#
CONFIGURABLE|PAYROLL_EXPENDITURES_CUBE|PAYROLL_EXPENDITURES_CUBE|F0B5E976B564741CE030A8C0FACA4FFB|FACT
#Configuration Parameter  <GroupPhysicalName> <ParamPhysicalName> <ParamValue> <DefaultValue> <UniversalID>
CONFIGPARAM|8i.TABLES.PARTITIONING|8i.TABLES.HSPNUMBER|2|Y|null
CONFIGPARAM|8i.TABLES.PARTITIONING|8i.TABLES.STOREIN|null|Y|null
CONFIGPARAM|8i.TABLES.IDENTIFICATION|8i.TABLES.DEPLOYABLE|true|Y|null
CONFIGPARAM|8i.TABLES.STORAGESPACE|8i.TABLES.TABLESPACE|null|Y|null
CONFIGPARAM|8i.TABLES.PARALLELISM|8i.TABLES.PARALLEL|PARALLEL|Y|null
CONFIGPARAM|8i.TABLES.PERFORMANCEPARAM|8i.TABLES.LOGGING|LOGGING|Y|null
CONFIGPARAM|8i.TABLES.PERFORMANCEPARAM|8i.TABLES.ESTIMATEPCT|99|Y|null
#
#Child Configuration  <ConfigTreePhysicalName> <ChildPhysicalName> <ChildLogicalName> <ChildUniversalID> <RefConfigurableUniversalID>
CHILDCONFIG|8i.TABLE.CONSTRAINT|FK_PAYROLL_EXPENDITURES_10637|FK_PAYROLL_EXPENDITURES_10637|null|F0B5E976B568741CE030A8C0FACA4FFB
CONFIGPARAM|8i.TABLE.CONSTRAINT.IDENTIFICATION|8i.TABLE.CONSTRAINT.DEPLOYABLE|true|Y|null
CONFIGPARAM|8i.TABLE.CONSTRAINT.CREATIONMETHOD|8i.TABLE.CONSTRAINT.USINGINDEX|false|Y|null
CONFIGPARAM|8i.TABLE.CONSTRAINT.CREATIONMETHOD|8i.TABLE.CONSTRAINT.INDEXTABLESPACE|null|Y|null
#
CHILDCONFIG|8i.TABLE.CONSTRAINT|FK_PAYROLL_EXPENDITURES_10675|FK_PAYROLL_EXPENDITURES_10675|null|F0B5E976B56B741CE030A8C0FACA4FFB
CONFIGPARAM|8i.TABLE.CONSTRAINT.IDENTIFICATION|8i.TABLE.CONSTRAINT.DEPLOYABLE|true|Y|null
CONFIGPARAM|8i.TABLE.CONSTRAINT.CREATIONMETHOD|8i.TABLE.CONSTRAINT.USINGINDEX|false|Y|null
CONFIGPARAM|8i.TABLE.CONSTRAINT.CREATIONMETHOD|8i.TABLE.CONSTRAINT.INDEXTABLESPACE|null|Y|null
#
CHILDCONFIG|8i.TABLE.CONSTRAINT|FK_PAYROLL_EXPENDITURES_10588|FK_PAYROLL_EXPENDITURES_10588|null|F0B5E976B565741CE030A8C0FACA4FFB
CONFIGPARAM|8i.TABLE.CONSTRAINT.IDENTIFICATION|8i.TABLE.CONSTRAINT.DEPLOYABLE|true|Y|null
CONFIGPARAM|8i.TABLE.CONSTRAINT.CREATIONMETHOD|8i.TABLE.CONSTRAINT.USINGINDEX|false|Y|null
CONFIGPARAM|8i.TABLE.CONSTRAINT.CREATIONMETHOD|8i.TABLE.CONSTRAINT.INDEXTABLESPACE|null|Y|null
#
#Mapping  <PhysicalName> <LogicalName> <UniversalID> <ModulePhysicalName> <ModuleLogicalName> <ModuleUniversalID> <ModuleType>
MAPPING|LOAD_EMP_DIM_STEP1|LOAD_EMP_DIM_STEP1|F0B5E976B5AE741CE030A8C0FACA4FFB|OWB_TST|OWB_TST|F0B5E976B44A741CE030A8C0FACA4FFB|DATAWAREHOUSE
#
#Mapping Stage Component  <PhysicalName> <LogicalName> <UniversalID> <ComponentType> <ReferencedProjectPhysicalName> <ReferencedProjectLogicalName>
#     <ReferencedProjectUniversalID> <ReferencedModulePhysicalName> <ReferencedModuleLogicalName> <ReferencedModuleUniversalID> 
#     <ReferencedModuleType> <ReferencedCategoryPhysicalName> <ReferencedCategoryLogicalName> <ReferencedCategoryUniversalID>
#     <ReferencedEntityPhysicalName> <ReferencedEntityLogicalName> <ReferencedEntityUniversalID> <ReferencedEntityType> <ReferencedFunctionSignature>
MAPPINGSTAGECOMPONENT|EMPLOYEE_DIM|EMPLOYEE_DIM|F0B5E976B5AF741CE030A8C0FACA4FFB|oracle.wh.service.impl.mapping.component.Dimension|PSOUG_FEB23|PSOUG_FEB23|F0B5E976B448741CE030A8C0FACA4FFB|OWB_TST|OWB_TST|F0B5E976B44A741CE030A8C0FACA4FFB|DATAWAREHOUSE|null|null|null|EMPLOYEE_DIM|EMPLOYEE_DIM|F0B5E976B4E1741CE030A8C0FACA4FFB|DIMENSION|null
#
#Mapping Property  <Key> <ValueType> <PropertyLevel> <UniversalID>
MAPPINGSTAGECOMPONENTPROPERTY|MAPPING.BOUNDNAME|STRING|0|F0B5E976B5B9741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
EMPLOYEE_DIM
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.DEFAULT.PRIMARY_SOURCE|STRING|0|null
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.PARMETERS.LOADTYPE|STRING|0|null
BEGIN_PROPERTYVALUE
INSERT
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.PARMETERS.UPDATETARGETCONDITION|STRING|0|null
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.PARMETERS.DELETETARGETCONDITION|STRING|0|null
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.PARMETERS.MATCHBYCONSTRAINT|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.PARMETERS.ADVANCEDMATCHBYCONSTRAINT|STRING|0|null
BEGIN_PROPERTYVALUE
No constraints
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.KEYS|STRING|0|F0B5E976B5B2741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
UKEY_PROPERTY_PARENT0
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.KEY.NAME|STRING|1|F0B5E976B5B8741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
EMPLOYEE_EMPLOYEE_L_UK
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.KEY.ID|STRING|1|F0B5E976B5B7741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
1
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.KEY.RECONCILEUOID|STRING|1|F0B5E976B5B6741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
F0B5E976B4F4741CE030A8C0FACA4FFB
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.KEY.KEYCOLUMNS|STRING|1|F0B5E976B5B5741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
&1
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.KEY.KEYTYPE|STRING|1|null
BEGIN_PROPERTYVALUE
UNIQUE
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.KEY.REFERENCEDKEYS|STRING|1|F0B5E976B5B4741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.KEY.REFERENCED_RECONCILEUOIDS|STRING|1|F0B5E976B5B3741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|OWBINTERNAL.APPEARANCE|STRING|0|F0B5E976B5B1741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
655|71|249|214|0|0
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.SCHEMA|STRING|0|F0B5E976B5D6741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.DBLINK|STRING|0|F0B5E976B5D5741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.METADATA.NEW|STRING|0|F0B5E976B5D4741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
Y
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.METADATA.DBLINK|STRING|0|F0B5E976B5D3741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.OWNER.IM|STRING|0|F0B5E976B5D2741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
OWB_TST
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.USEPEL|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.PARTITIONGRANULARITY|STRING|0|null
BEGIN_PROPERTYVALUE
UNKNOWN
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.DIRECTPEL|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.IGNOREEXISTINGDATA|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.EXTRACT_HINT|STRING|0|F0B5E976B5D1741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.LOAD_HINT|STRING|0|F0B5E976B5D0741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
APPEND PARALLEL(<TABLE_ALIAS>, DEFAULT, DEFAULT)
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.REENABLECONSTRAINTS|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
true
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.EXCEPTIONS|STRING|0|F0B5E976B5CF741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.PARTITIONNAME|STRING|0|F0B5E976B5CE741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.SUBPARTITIONNAME|STRING|0|F0B5E976B5CD741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.SORTEDINDEXES|STRING|0|F0B5E976B5CC741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.SINGLEROW|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.TRAILINGNULLCOLS|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.SKIP|INTEGER|0|null
BEGIN_PROPERTYVALUE
0
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.FILE|STRING|0|F0B5E976B5CB741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SAPTABLE.TABLETYPE|STRING|0|F0B5E976B5CA741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SAPTABLE.EXTRACTIONMETHOD|STRING|0|F0B5E976B5C9741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
#
#Mapping Stage Component Parameter Group  <PhysicalName> <LogicalName> <UniversalID> <Direction> <ReferencedProjectPhysicalName>
#     <ReferencedProjectLogicalName> <ReferencedProjectUniversalID> <ReferencedModulePhysicalName> <ReferencedModuleLogicalName> <ReferencedModuleUniversalID> 
#     <ReferencedModuleType> <ReferencedCategoryPhysicalName> <ReferencedCategoryLogicalName> <ReferencedCategoryUniversalID>
#     <ReferencedEntityPhysicalName> <ReferencedEntityLogicalName> <ReferencedEntityUniversalID> <ReferencedEntityType>
#     <CurrentDisplaySetPhysicalName> <CurrentDisplaySetLogicalName> <CurrentDisplaySetUniversalID> <CurrentDisplaySetType>
MAPPINGPARAMETERGROUP|INOUTGRP1|INOUTGRP1|F0B5E976B5B0741CE030A8C0FACA4FFB|3|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|0
#
#Mapping Parameter  <PhysicalName> <LogicalName> <UniversalID> <DataType> <Length> <Precision> <Scale> <ReferencedItemPhysicalName> <ReferencedItemLogicalName> <ReferencedItemUniversalID>
MAPPINGPARAMETER|DEPARTMENT_L_NAME|DEPARTMENT_L NAME|F0B5E976B5BA741CE030A8C0FACA4FFB|VARCHAR2|40|0|0|DEPARTMENT_L_NAME|DEPARTMENT_L NAME|F0B5E976B4EF741CE030A8C0FACA4FFB
BEGIN_EXPRESSION
"EMPLOYEE_DIM"."DEPARTMENT_L_NAME"
END_EXPRESSION
MAPPINGPARAMETERPROPERTY|MAPPING.BOUNDNAME|STRING|0|F0B5E976B5BB741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
DEPARTMENT_L_NAME
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.INSERTLOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATELOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEMATCHING|STRING|0|F0B5E976B5DA741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEOPERATION|STRING|0|null
BEGIN_PROPERTYVALUE
=
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.DELETEMATCHING|STRING|0|F0B5E976B5D9741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
#
MAPPINGPARAMETER|EMPLOYEE_L_ID|EMPLOYEE_L ID|F0B5E976B5BC741CE030A8C0FACA4FFB|NUMBER|40|0|0|EMPLOYEE_L_ID|EMPLOYEE_L ID|F0B5E976B4F6741CE030A8C0FACA4FFB
BEGIN_EXPRESSION
"EMPLOYEE_DIM"."EMPLOYEE_L_ID"
END_EXPRESSION
MAPPINGPARAMETERPROPERTY|MAPPING.BOUNDNAME|STRING|0|F0B5E976B5BD741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
EMPLOYEE_L_ID
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.INSERTLOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATELOADING|STRING|0|F0B5E976B5DB741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEMATCHING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEOPERATION|STRING|0|null
BEGIN_PROPERTYVALUE
=
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.DELETEMATCHING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
#
MAPPINGPARAMETER|EMPLOYEE_L_NAME|EMPLOYEE_L_NAME|F0B5E976B5BE741CE030A8C0FACA4FFB|VARCHAR2|40|0|0|EMPLOYEE_L_NAME|EMPLOYEE_L_NAME|F0B5E976B4FA741CE030A8C0FACA4FFB
BEGIN_EXPRESSION
"EMPLOYEE_DIM"."EMPLOYEE_L_NAME"
END_EXPRESSION
MAPPINGPARAMETERPROPERTY|MAPPING.BOUNDNAME|STRING|0|F0B5E976B5BF741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
EMPLOYEE_L_NAME
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.INSERTLOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATELOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEMATCHING|STRING|0|F0B5E976B5DD741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEOPERATION|STRING|0|null
BEGIN_PROPERTYVALUE
=
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.DELETEMATCHING|STRING|0|F0B5E976B5DC741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
#
MAPPINGPARAMETER|TOTAL_L_NAME|TOTAL_L NAME|F0B5E976B5C0741CE030A8C0FACA4FFB|VARCHAR2|10|0|0|TOTAL_L_NAME|TOTAL_L NAME|F0B5E976B4E8741CE030A8C0FACA4FFB
BEGIN_EXPRESSION
"EMPLOYEE_DIM"."TOTAL_L_NAME"
END_EXPRESSION
MAPPINGPARAMETERPROPERTY|MAPPING.BOUNDNAME|STRING|0|F0B5E976B5C1741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
TOTAL_L_NAME
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.INSERTLOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATELOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEMATCHING|STRING|0|F0B5E976B5DF741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEOPERATION|STRING|0|null
BEGIN_PROPERTYVALUE
=
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.DELETEMATCHING|STRING|0|F0B5E976B5DE741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
#
#Mapping Display Set  <PhysicalName> <LogicalName> <UniversalID> <ReferencedAttrSetPhysicalName> <ReferencedAttrSetName> <ReferencedAttrSetUniversalID>
MAPPINGDISPLAYSET|DEPARTMENTAL_H|DEPARTMENTAL_H|F0B5E976B5C2741CE030A8C0FACA4FFB|DEPARTMENTAL_H|DEPARTMENTAL_H|F0B5E976B4FC741CE030A8C0FACA4FFB
MAPPINGDISPLAYSETPARAMETER|DEPARTMENT_L_NAME|DEPARTMENT_L NAME|F0B5E976B5BA741CE030A8C0FACA4FFB
MAPPINGDISPLAYSETPARAMETER|EMPLOYEE_L_NAME|EMPLOYEE_L_NAME|F0B5E976B5BE741CE030A8C0FACA4FFB
MAPPINGDISPLAYSETPARAMETER|TOTAL_L_NAME|TOTAL_L NAME|F0B5E976B5C0741CE030A8C0FACA4FFB
MAPPINGDISPLAYSETPARAMETER|EMPLOYEE_L_ID|EMPLOYEE_L ID|F0B5E976B5BC741CE030A8C0FACA4FFB
#
MAPPINGSTAGECOMPONENT|CONST|CONST|F0B5E976B5ED741CE030A8C0FACA4FFB|oracle.wh.service.impl.mapping.component.Variables|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null
#
#Mapping Property  <Key> <ValueType> <PropertyLevel> <UniversalID>
MAPPINGSTAGECOMPONENTPROPERTY|OWBINTERNAL.APPEARANCE|STRING|0|F0B5E976B5F0741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
219|4|163|144|0|1
END_PROPERTYVALUE
#
#
#Mapping Stage Component Parameter Group  <PhysicalName> <LogicalName> <UniversalID> <Direction> <ReferencedProjectPhysicalName>
#     <ReferencedProjectLogicalName> <ReferencedProjectUniversalID> <ReferencedModulePhysicalName> <ReferencedModuleLogicalName> <ReferencedModuleUniversalID> 
#     <ReferencedModuleType> <ReferencedCategoryPhysicalName> <ReferencedCategoryLogicalName> <ReferencedCategoryUniversalID>
#     <ReferencedEntityPhysicalName> <ReferencedEntityLogicalName> <ReferencedEntityUniversalID> <ReferencedEntityType>
#     <CurrentDisplaySetPhysicalName> <CurrentDisplaySetLogicalName> <CurrentDisplaySetUniversalID> <CurrentDisplaySetType>
MAPPINGPARAMETERGROUP|OUTGRP1|OUTGRP1|F0B5E976B5EE741CE030A8C0FACA4FFB|2|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|0
#
#Mapping Parameter  <PhysicalName> <LogicalName> <UniversalID> <DataType> <Length> <Precision> <Scale> <ReferencedItemPhysicalName> <ReferencedItemLogicalName> <ReferencedItemUniversalID>
MAPPINGPARAMETER|TOTAL|OUTPUT1|F0B5E976B5F1741CE030A8C0FACA4FFB|VARCHAR2|10|0|0|null|null|null
BEGIN_EXPRESSION
'All'
END_EXPRESSION
#
MAPPINGSTAGECOMPONENT|JOIN|JOIN|F0B5E976B663741CE030A8C0FACA4FFB|oracle.wh.service.impl.mapping.component.Join|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null
#
#Mapping Property  <Key> <ValueType> <PropertyLevel> <UniversalID>
MAPPINGSTAGECOMPONENTPROPERTY|JOIN.JOIN_CONDITION|STRING|0|F0B5E976B66B741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
&1 = &2
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|$MDLINTERNAL.EXPANDED_JOIN_CONDITION|STRING|0|null
BEGIN_PROPERTYVALUE
F0B5E976B66F741CE030A8C0FACA4FFB = F0B5E976B671741CE030A8C0FACA4FFB
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|JOIN.INPUT.JOIN_CONDITION_USER_MODIFIED_FLAG|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|OWBINTERNAL.APPEARANCE|STRING|0|F0B5E976B66A741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
330|199|178|260|6|0
END_PROPERTYVALUE
#
#
#Mapping Stage Component Parameter Group  <PhysicalName> <LogicalName> <UniversalID> <Direction> <ReferencedProjectPhysicalName>
#     <ReferencedProjectLogicalName> <ReferencedProjectUniversalID> <ReferencedModulePhysicalName> <ReferencedModuleLogicalName> <ReferencedModuleUniversalID> 
#     <ReferencedModuleType> <ReferencedCategoryPhysicalName> <ReferencedCategoryLogicalName> <ReferencedCategoryUniversalID>
#     <ReferencedEntityPhysicalName> <ReferencedEntityLogicalName> <ReferencedEntityUniversalID> <ReferencedEntityType>
#     <CurrentDisplaySetPhysicalName> <CurrentDisplaySetLogicalName> <CurrentDisplaySetUniversalID> <CurrentDisplaySetType>
MAPPINGPARAMETERGROUP|INGRP1|INGRP1|F0B5E976B664741CE030A8C0FACA4FFB|1|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|0
MAPPINGPARAMETERGROUPPROPERTY|JOIN.INPUT.DEFAULT_JOIN_CONDITION|STRING|0|F0B5E976B665741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
&1 = &2
END_PROPERTYVALUE
#
#
#Mapping Parameter  <PhysicalName> <LogicalName> <UniversalID> <DataType> <Length> <Precision> <Scale> <ReferencedItemPhysicalName> <ReferencedItemLogicalName> <ReferencedItemUniversalID>
MAPPINGPARAMETER|ENAME|ENAME|F0B5E976B66C741CE030A8C0FACA4FFB|VARCHAR2|10|0|0|null|null|null
#
MAPPINGPARAMETER|DEPTNO|DEPTNO|F0B5E976B66F741CE030A8C0FACA4FFB|NUMBER|0|2|0|null|null|null
#
MAPPINGPARAMETERGROUP|INGRP2|INGRP2|F0B5E976B666741CE030A8C0FACA4FFB|1|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|0
MAPPINGPARAMETERGROUPPROPERTY|JOIN.INPUT.DEFAULT_JOIN_CONDITION|STRING|0|F0B5E976B667741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
#
#Mapping Parameter  <PhysicalName> <LogicalName> <UniversalID> <DataType> <Length> <Precision> <Scale> <ReferencedItemPhysicalName> <ReferencedItemLogicalName> <ReferencedItemUniversalID>
MAPPINGPARAMETER|DEPTNO|DEPTNO|F0B5E976B671741CE030A8C0FACA4FFB|NUMBER|0|2|0|null|null|null
#
MAPPINGPARAMETER|DNAME|DNAME|F0B5E976B675741CE030A8C0FACA4FFB|VARCHAR2|14|0|0|null|null|null
#
MAPPINGPARAMETERGROUP|OUTGRP1|OUTGRP1|F0B5E976B668741CE030A8C0FACA4FFB|2|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|0
#
#Mapping Parameter  <PhysicalName> <LogicalName> <UniversalID> <DataType> <Length> <Precision> <Scale> <ReferencedItemPhysicalName> <ReferencedItemLogicalName> <ReferencedItemUniversalID>
MAPPINGPARAMETER|ENAME|ENAME|F0B5E976B66D741CE030A8C0FACA4FFB|VARCHAR2|10|0|0|null|null|null
BEGIN_EXPRESSION
&0
END_EXPRESSION
#
MAPPINGPARAMETER|DEPTNO|DEPTNO|F0B5E976B670741CE030A8C0FACA4FFB|NUMBER|0|2|0|null|null|null
BEGIN_EXPRESSION
&1
END_EXPRESSION
#
MAPPINGPARAMETER|DEPTNO_1|DEPTNO_1|F0B5E976B672741CE030A8C0FACA4FFB|NUMBER|0|2|0|null|null|null
BEGIN_EXPRESSION
&2
END_EXPRESSION
#
MAPPINGPARAMETER|DNAME|DNAME|F0B5E976B676741CE030A8C0FACA4FFB|VARCHAR2|14|0|0|null|null|null
BEGIN_EXPRESSION
&3
END_EXPRESSION
MAPPINGPARAMETERPROPERTY|$MDLINTERNAL.JOIN_OUTPUT_PARAMETERS_UOID_MAP|STRING|0|null
BEGIN_PROPERTYVALUE
F0B5E976B66D741CE030A8C0FACA4FFB=F0B5E976B66C741CE030A8C0FACA4FFB
F0B5E976B670741CE030A8C0FACA4FFB=F0B5E976B66F741CE030A8C0FACA4FFB
F0B5E976B672741CE030A8C0FACA4FFB=F0B5E976B671741CE030A8C0FACA4FFB
F0B5E976B676741CE030A8C0FACA4FFB=F0B5E976B675741CE030A8C0FACA4FFB
END_PROPERTYVALUE
#
#
MAPPINGSTAGECOMPONENT|EMPLOYEE_DIM_SEQ|EMPLOYEE_DIM_SEQ|F0B5E976B5E0741CE030A8C0FACA4FFB|oracle.wh.service.impl.mapping.component.Sequence|PSOUG_FEB23|PSOUG_FEB23|F0B5E976B448741CE030A8C0FACA4FFB|OWB_TST|OWB_TST|F0B5E976B44A741CE030A8C0FACA4FFB|DATAWAREHOUSE|null|null|null|EMPLOYEE_DIM_SEQ|EMPLOYEE_DIM_SEQ|F0B5E976B452741CE030A8C0FACA4FFB|SEQUENCE|null
#
#Mapping Property  <Key> <ValueType> <PropertyLevel> <UniversalID>
MAPPINGSTAGECOMPONENTPROPERTY|MAPPING.BOUNDNAME|STRING|0|F0B5E976B5E7741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
EMPLOYEE_DIM_SEQ
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|OWBINTERNAL.APPEARANCE|STRING|0|F0B5E976B5E6741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
357|5|171|168|0|1
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.SCHEMA|STRING|0|F0B5E976B5E5741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.DBLINK|STRING|0|F0B5E976B5E4741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.METADATA.NEW|STRING|0|F0B5E976B5EB741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
Y
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.METADATA.DBLINK|STRING|0|F0B5E976B5E3741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.OWNER.IM|STRING|0|F0B5E976B5EA741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
OWB_TST
END_PROPERTYVALUE
#
#
#Mapping Stage Component Parameter Group  <PhysicalName> <LogicalName> <UniversalID> <Direction> <ReferencedProjectPhysicalName>
#     <ReferencedProjectLogicalName> <ReferencedProjectUniversalID> <ReferencedModulePhysicalName> <ReferencedModuleLogicalName> <ReferencedModuleUniversalID> 
#     <ReferencedModuleType> <ReferencedCategoryPhysicalName> <ReferencedCategoryLogicalName> <ReferencedCategoryUniversalID>
#     <ReferencedEntityPhysicalName> <ReferencedEntityLogicalName> <ReferencedEntityUniversalID> <ReferencedEntityType>
#     <CurrentDisplaySetPhysicalName> <CurrentDisplaySetLogicalName> <CurrentDisplaySetUniversalID> <CurrentDisplaySetType>
MAPPINGPARAMETERGROUP|OUTGRP1|OUTGRP1|F0B5E976B5E1741CE030A8C0FACA4FFB|2|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|0
#
#Mapping Parameter  <PhysicalName> <LogicalName> <UniversalID> <DataType> <Length> <Precision> <Scale> <ReferencedItemPhysicalName> <ReferencedItemLogicalName> <ReferencedItemUniversalID>
MAPPINGPARAMETER|NEXTVAL|NEXTVAL|F0B5E976B5E8741CE030A8C0FACA4FFB|NUMBER|0|0|0|NEXTVAL|NEXTVAL|F0B5E976B453741CE030A8C0FACA4FFB
BEGIN_EXPRESSION
"EMPLOYEE_DIM_SEQ".NEXTVAL
END_EXPRESSION
#
MAPPINGPARAMETER|CURRVAL|CURRVAL|F0B5E976B5E9741CE030A8C0FACA4FFB|NUMBER|0|0|0|CURRVAL|CURRVAL|F0B5E976B454741CE030A8C0FACA4FFB
BEGIN_EXPRESSION
"EMPLOYEE_DIM_SEQ".CURRVAL
END_EXPRESSION
#
MAPPINGSTAGECOMPONENT|DEPT|DEPT|F0B5E976B5F6741CE030A8C0FACA4FFB|oracle.wh.service.impl.mapping.component.Table|PSOUG_FEB23|PSOUG_FEB23|F0B5E976B448741CE030A8C0FACA4FFB|SCOTT|SCOTT|F0B5E976B595741CE030A8C0FACA4FFB|ORACLEINSTALLEDMODULE|null|null|null|DEPT|DEPT|F0B5E976B597741CE030A8C0FACA4FFB|TABLE|null
#
#Mapping Property  <Key> <ValueType> <PropertyLevel> <UniversalID>
MAPPINGSTAGECOMPONENTPROPERTY|MAPPING.BOUNDNAME|STRING|0|F0B5E976B60E741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
DEPT
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.DEFAULT.PRIMARY_SOURCE|STRING|0|null
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.PARMETERS.LOADTYPE|STRING|0|null
BEGIN_PROPERTYVALUE
INSERT
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.PARMETERS.UPDATETARGETCONDITION|STRING|0|null
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.PARMETERS.DELETETARGETCONDITION|STRING|0|null
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.PARMETERS.MATCHBYCONSTRAINT|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.PARMETERS.ADVANCEDMATCHBYCONSTRAINT|STRING|0|null
BEGIN_PROPERTYVALUE
No constraints
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.KEYS|STRING|0|F0B5E976B606741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
UKEY_PROPERTY_PARENT0
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.KEY.NAME|STRING|1|F0B5E976B60D741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
PK_DEPT
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.KEY.ID|STRING|1|F0B5E976B60C741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
3
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.KEY.RECONCILEUOID|STRING|1|F0B5E976B60B741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
F0B5E976B59B741CE030A8C0FACA4FFB
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.KEY.KEYCOLUMNS|STRING|1|F0B5E976B60A741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
&0
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.KEY.KEYTYPE|STRING|1|F0B5E976B609741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
PRIMARY
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.KEY.REFERENCEDKEYS|STRING|1|F0B5E976B608741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
6
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.KEY.REFERENCED_RECONCILEUOIDS|STRING|1|F0B5E976B607741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|OWBINTERNAL.APPEARANCE|STRING|0|F0B5E976B605741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
36|356|175|213|0|0
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.SCHEMA|STRING|0|F0B5E976B604741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.DBLINK|STRING|0|F0B5E976B603741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.METADATA.NEW|STRING|0|F0B5E976B617741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
Y
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.METADATA.DBLINK|STRING|0|F0B5E976B602741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
SCOTT_LINK.BAYONTECHNOLOGIES.COM
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.OWNER.IM|STRING|0|F0B5E976B616741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
SCOTT
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.USEPEL|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.PARTITIONGRANULARITY|STRING|0|null
BEGIN_PROPERTYVALUE
UNKNOWN
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.DIRECTPEL|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.IGNOREEXISTINGDATA|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.EXTRACT_HINT|STRING|0|F0B5E976B601741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.LOAD_HINT|STRING|0|F0B5E976B600741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
APPEND PARALLEL(<TABLE_ALIAS>, DEFAULT, DEFAULT)
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.REENABLECONSTRAINTS|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
true
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.EXCEPTIONS|STRING|0|F0B5E976B5FF741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.PARTITIONNAME|STRING|0|F0B5E976B5FE741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.SUBPARTITIONNAME|STRING|0|F0B5E976B5FD741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.SORTEDINDEXES|STRING|0|F0B5E976B5FC741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.SINGLEROW|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.TRAILINGNULLCOLS|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.SKIP|INTEGER|0|null
BEGIN_PROPERTYVALUE
0
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.FILE|STRING|0|F0B5E976B5FB741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SAPTABLE.TABLETYPE|STRING|0|F0B5E976B5FA741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SAPTABLE.EXTRACTIONMETHOD|STRING|0|F0B5E976B5F9741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
#
#Mapping Stage Component Parameter Group  <PhysicalName> <LogicalName> <UniversalID> <Direction> <ReferencedProjectPhysicalName>
#     <ReferencedProjectLogicalName> <ReferencedProjectUniversalID> <ReferencedModulePhysicalName> <ReferencedModuleLogicalName> <ReferencedModuleUniversalID> 
#     <ReferencedModuleType> <ReferencedCategoryPhysicalName> <ReferencedCategoryLogicalName> <ReferencedCategoryUniversalID>
#     <ReferencedEntityPhysicalName> <ReferencedEntityLogicalName> <ReferencedEntityUniversalID> <ReferencedEntityType>
#     <CurrentDisplaySetPhysicalName> <CurrentDisplaySetLogicalName> <CurrentDisplaySetUniversalID> <CurrentDisplaySetType>
MAPPINGPARAMETERGROUP|INOUTGRP1|INOUTGRP1|F0B5E976B5F7741CE030A8C0FACA4FFB|3|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|0
#
#Mapping Parameter  <PhysicalName> <LogicalName> <UniversalID> <DataType> <Length> <Precision> <Scale> <ReferencedItemPhysicalName> <ReferencedItemLogicalName> <ReferencedItemUniversalID>
MAPPINGPARAMETER|DEPTNO|DEPTNO|F0B5E976B60F741CE030A8C0FACA4FFB|NUMBER|0|2|0|DEPTNO|DEPTNO|F0B5E976B598741CE030A8C0FACA4FFB
BEGIN_EXPRESSION
"DEPT_OWB_TST_L_SCOTT_L"."DEPTNO"
END_EXPRESSION
MAPPINGPARAMETERPROPERTY|MAPPING.BOUNDNAME|STRING|0|F0B5E976B610741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
DEPTNO
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.INSERTLOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATELOADING|STRING|0|F0B5E976B61A741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEMATCHING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEOPERATION|STRING|0|null
BEGIN_PROPERTYVALUE
=
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.DELETEMATCHING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
#
MAPPINGPARAMETER|DNAME|DNAME|F0B5E976B611741CE030A8C0FACA4FFB|VARCHAR2|14|0|0|DNAME|DNAME|F0B5E976B599741CE030A8C0FACA4FFB
BEGIN_EXPRESSION
"DEPT_OWB_TST_L_SCOTT_L"."DNAME"
END_EXPRESSION
MAPPINGPARAMETERPROPERTY|MAPPING.BOUNDNAME|STRING|0|F0B5E976B612741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
DNAME
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.INSERTLOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATELOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEMATCHING|STRING|0|F0B5E976B61C741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEOPERATION|STRING|0|null
BEGIN_PROPERTYVALUE
=
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.DELETEMATCHING|STRING|0|F0B5E976B61B741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
#
MAPPINGPARAMETER|LOC|LOC|F0B5E976B613741CE030A8C0FACA4FFB|VARCHAR2|13|0|0|LOC|LOC|F0B5E976B59A741CE030A8C0FACA4FFB
BEGIN_EXPRESSION
"DEPT_OWB_TST_L_SCOTT_L"."LOC"
END_EXPRESSION
MAPPINGPARAMETERPROPERTY|MAPPING.BOUNDNAME|STRING|0|F0B5E976B614741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
LOC
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.INSERTLOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATELOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEMATCHING|STRING|0|F0B5E976B61E741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEOPERATION|STRING|0|null
BEGIN_PROPERTYVALUE
=
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.DELETEMATCHING|STRING|0|F0B5E976B61D741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
#
MAPPINGSTAGECOMPONENT|EMP|EMP|F0B5E976B61F741CE030A8C0FACA4FFB|oracle.wh.service.impl.mapping.component.Table|PSOUG_FEB23|PSOUG_FEB23|F0B5E976B448741CE030A8C0FACA4FFB|SCOTT|SCOTT|F0B5E976B595741CE030A8C0FACA4FFB|ORACLEINSTALLEDMODULE|null|null|null|EMP|EMP|F0B5E976B59D741CE030A8C0FACA4FFB|TABLE|null
#
#Mapping Property  <Key> <ValueType> <PropertyLevel> <UniversalID>
MAPPINGSTAGECOMPONENTPROPERTY|MAPPING.BOUNDNAME|STRING|0|F0B5E976B63F741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
EMP
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.DEFAULT.PRIMARY_SOURCE|STRING|0|null
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.PARMETERS.LOADTYPE|STRING|0|null
BEGIN_PROPERTYVALUE
INSERT
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.PARMETERS.UPDATETARGETCONDITION|STRING|0|null
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.PARMETERS.DELETETARGETCONDITION|STRING|0|null
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.PARMETERS.MATCHBYCONSTRAINT|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.PARMETERS.ADVANCEDMATCHBYCONSTRAINT|STRING|0|null
BEGIN_PROPERTYVALUE
No constraints
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.KEYS|STRING|0|F0B5E976B637741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
UKEY_PROPERTY_PARENT0
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.KEY.NAME|STRING|1|F0B5E976B63E741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
PK_EMP
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.KEY.ID|STRING|1|F0B5E976B63D741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
5
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.KEY.RECONCILEUOID|STRING|1|F0B5E976B63C741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
F0B5E976B5A6741CE030A8C0FACA4FFB
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.KEY.KEYCOLUMNS|STRING|1|F0B5E976B63B741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
&0
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.KEY.KEYTYPE|STRING|1|F0B5E976B63A741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
PRIMARY
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.KEY.REFERENCEDKEYS|STRING|1|F0B5E976B639741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.KEY.REFERENCED_RECONCILEUOIDS|STRING|1|F0B5E976B638741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.KEYS|STRING|0|F0B5E976B62F741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
FKEY_PROPERTY_PARENT0
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.KEY.NAME|STRING|1|F0B5E976B636741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
FK_DEPTNO
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.KEY.ID|STRING|1|F0B5E976B635741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
6
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.KEY.RECONCILEUOID|STRING|1|F0B5E976B634741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
F0B5E976B5A8741CE030A8C0FACA4FFB
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.KEY.KEYCOLUMNS|STRING|1|F0B5E976B633741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
&7
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.KEY.KEYTYPE|STRING|1|F0B5E976B632741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
FOREIGN
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.KEY.REFERENCEDKEYS|STRING|1|F0B5E976B631741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
3
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.KEY.REFERENCED_RECONCILEUOIDS|STRING|1|F0B5E976B630741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|OWBINTERNAL.APPEARANCE|STRING|0|F0B5E976B62E741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
45|41|175|328|0|0
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.SCHEMA|STRING|0|F0B5E976B62D741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.DBLINK|STRING|0|F0B5E976B62C741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.METADATA.NEW|STRING|0|F0B5E976B651741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
Y
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.METADATA.DBLINK|STRING|0|F0B5E976B62B741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
SCOTT_LINK.BAYONTECHNOLOGIES.COM
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.OWNER.IM|STRING|0|F0B5E976B650741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
SCOTT
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.USEPEL|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.PARTITIONGRANULARITY|STRING|0|null
BEGIN_PROPERTYVALUE
UNKNOWN
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.DIRECTPEL|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.IGNOREEXISTINGDATA|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.EXTRACT_HINT|STRING|0|F0B5E976B62A741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.LOAD_HINT|STRING|0|F0B5E976B629741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
APPEND PARALLEL(<TABLE_ALIAS>, DEFAULT, DEFAULT)
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.REENABLECONSTRAINTS|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
true
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.EXCEPTIONS|STRING|0|F0B5E976B628741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.PARTITIONNAME|STRING|0|F0B5E976B627741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.SUBPARTITIONNAME|STRING|0|F0B5E976B626741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.SORTEDINDEXES|STRING|0|F0B5E976B625741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.SINGLEROW|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.TRAILINGNULLCOLS|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.SKIP|INTEGER|0|null
BEGIN_PROPERTYVALUE
0
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.FILE|STRING|0|F0B5E976B624741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SAPTABLE.TABLETYPE|STRING|0|F0B5E976B623741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SAPTABLE.EXTRACTIONMETHOD|STRING|0|F0B5E976B622741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
#
#Mapping Stage Component Parameter Group  <PhysicalName> <LogicalName> <UniversalID> <Direction> <ReferencedProjectPhysicalName>
#     <ReferencedProjectLogicalName> <ReferencedProjectUniversalID> <ReferencedModulePhysicalName> <ReferencedModuleLogicalName> <ReferencedModuleUniversalID> 
#     <ReferencedModuleType> <ReferencedCategoryPhysicalName> <ReferencedCategoryLogicalName> <ReferencedCategoryUniversalID>
#     <ReferencedEntityPhysicalName> <ReferencedEntityLogicalName> <ReferencedEntityUniversalID> <ReferencedEntityType>
#     <CurrentDisplaySetPhysicalName> <CurrentDisplaySetLogicalName> <CurrentDisplaySetUniversalID> <CurrentDisplaySetType>
MAPPINGPARAMETERGROUP|INOUTGRP1|INOUTGRP1|F0B5E976B620741CE030A8C0FACA4FFB|3|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|0
#
#Mapping Parameter  <PhysicalName> <LogicalName> <UniversalID> <DataType> <Length> <Precision> <Scale> <ReferencedItemPhysicalName> <ReferencedItemLogicalName> <ReferencedItemUniversalID>
MAPPINGPARAMETER|EMPNO|EMPNO|F0B5E976B640741CE030A8C0FACA4FFB|NUMBER|0|4|0|EMPNO|EMPNO|F0B5E976B59E741CE030A8C0FACA4FFB
BEGIN_EXPRESSION
"EMP_OWB_TST_L_SCOTT_L"."EMPNO"
END_EXPRESSION
MAPPINGPARAMETERPROPERTY|MAPPING.BOUNDNAME|STRING|0|F0B5E976B641741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
EMPNO
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.INSERTLOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATELOADING|STRING|0|F0B5E976B654741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEMATCHING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEOPERATION|STRING|0|null
BEGIN_PROPERTYVALUE
=
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.DELETEMATCHING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
#
MAPPINGPARAMETER|ENAME|ENAME|F0B5E976B642741CE030A8C0FACA4FFB|VARCHAR2|10|0|0|ENAME|ENAME|F0B5E976B59F741CE030A8C0FACA4FFB
BEGIN_EXPRESSION
"EMP_OWB_TST_L_SCOTT_L"."ENAME"
END_EXPRESSION
MAPPINGPARAMETERPROPERTY|MAPPING.BOUNDNAME|STRING|0|F0B5E976B643741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
ENAME
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.INSERTLOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATELOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEMATCHING|STRING|0|F0B5E976B656741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEOPERATION|STRING|0|null
BEGIN_PROPERTYVALUE
=
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.DELETEMATCHING|STRING|0|F0B5E976B655741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
#
MAPPINGPARAMETER|JOB|JOB|F0B5E976B644741CE030A8C0FACA4FFB|VARCHAR2|9|0|0|JOB|JOB|F0B5E976B5A0741CE030A8C0FACA4FFB
BEGIN_EXPRESSION
"EMP_OWB_TST_L_SCOTT_L"."JOB"
END_EXPRESSION
MAPPINGPARAMETERPROPERTY|MAPPING.BOUNDNAME|STRING|0|F0B5E976B645741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
JOB
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.INSERTLOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATELOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEMATCHING|STRING|0|F0B5E976B658741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEOPERATION|STRING|0|null
BEGIN_PROPERTYVALUE
=
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.DELETEMATCHING|STRING|0|F0B5E976B657741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
#
MAPPINGPARAMETER|MGR|MGR|F0B5E976B646741CE030A8C0FACA4FFB|NUMBER|0|4|0|MGR|MGR|F0B5E976B5A1741CE030A8C0FACA4FFB
BEGIN_EXPRESSION
"EMP_OWB_TST_L_SCOTT_L"."MGR"
END_EXPRESSION
MAPPINGPARAMETERPROPERTY|MAPPING.BOUNDNAME|STRING|0|F0B5E976B647741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
MGR
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.INSERTLOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATELOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEMATCHING|STRING|0|F0B5E976B65A741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEOPERATION|STRING|0|null
BEGIN_PROPERTYVALUE
=
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.DELETEMATCHING|STRING|0|F0B5E976B659741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
#
MAPPINGPARAMETER|HIREDATE|HIREDATE|F0B5E976B648741CE030A8C0FACA4FFB|DATE|0|0|0|HIREDATE|HIREDATE|F0B5E976B5A2741CE030A8C0FACA4FFB
BEGIN_EXPRESSION
"EMP_OWB_TST_L_SCOTT_L"."HIREDATE"
END_EXPRESSION
MAPPINGPARAMETERPROPERTY|MAPPING.BOUNDNAME|STRING|0|F0B5E976B649741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
HIREDATE
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.INSERTLOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATELOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEMATCHING|STRING|0|F0B5E976B65C741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEOPERATION|STRING|0|null
BEGIN_PROPERTYVALUE
=
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.DELETEMATCHING|STRING|0|F0B5E976B65B741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
#
MAPPINGPARAMETER|SAL|SAL|F0B5E976B64A741CE030A8C0FACA4FFB|NUMBER|0|7|2|SAL|SAL|F0B5E976B5A3741CE030A8C0FACA4FFB
BEGIN_EXPRESSION
"EMP_OWB_TST_L_SCOTT_L"."SAL"
END_EXPRESSION
MAPPINGPARAMETERPROPERTY|MAPPING.BOUNDNAME|STRING|0|F0B5E976B64B741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
SAL
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.INSERTLOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATELOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEMATCHING|STRING|0|F0B5E976B65E741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEOPERATION|STRING|0|null
BEGIN_PROPERTYVALUE
=
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.DELETEMATCHING|STRING|0|F0B5E976B65D741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
#
MAPPINGPARAMETER|COMM|COMM|F0B5E976B64C741CE030A8C0FACA4FFB|NUMBER|0|7|2|COMM|COMM|F0B5E976B5A4741CE030A8C0FACA4FFB
BEGIN_EXPRESSION
"EMP_OWB_TST_L_SCOTT_L"."COMM"
END_EXPRESSION
MAPPINGPARAMETERPROPERTY|MAPPING.BOUNDNAME|STRING|0|F0B5E976B64D741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
COMM
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.INSERTLOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATELOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEMATCHING|STRING|0|F0B5E976B660741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEOPERATION|STRING|0|null
BEGIN_PROPERTYVALUE
=
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.DELETEMATCHING|STRING|0|F0B5E976B65F741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
#
MAPPINGPARAMETER|DEPTNO|DEPTNO|F0B5E976B64E741CE030A8C0FACA4FFB|NUMBER|0|2|0|DEPTNO|DEPTNO|F0B5E976B5A5741CE030A8C0FACA4FFB
BEGIN_EXPRESSION
"EMP_OWB_TST_L_SCOTT_L"."DEPTNO"
END_EXPRESSION
MAPPINGPARAMETERPROPERTY|MAPPING.BOUNDNAME|STRING|0|F0B5E976B64F741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
DEPTNO
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.INSERTLOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATELOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEMATCHING|STRING|0|F0B5E976B662741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEOPERATION|STRING|0|null
BEGIN_PROPERTYVALUE
=
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.DELETEMATCHING|STRING|0|F0B5E976B661741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
#
#Mapping Parameter Connection  <TargetStageComponentPhysicalName>  <TargetStageComponentLogicalName> <TargetStageComponentUniversalID>
#     <TargetParameterGroupPhysicalName>  <TargetParameterGroupLogicalName> <TargetParameterGroupUniversalID>
#     <TargetParameterPhysicalName> <TargetParameterLogicalName> <TargetParameterUniversalID> <SourceStageComponentPhysicalName>
#     <SourceStageComponentLogicalName> <SourceStageComponentUniversalID> <SourceParameterGroupPhysicalName> <SourceParameterGroupLogicalName>
#     <SourceParameterGroupUniversalID> <SourceParameterPhysicalName> <SourceParameterLogicalName> <SourceParameterUniversalID>
MAPPINGPARAMETERCONNECTION|EMPLOYEE_DIM|EMPLOYEE_DIM|F0B5E976B5AF741CE030A8C0FACA4FFB|INOUTGRP1|INOUTGRP1|F0B5E976B5B0741CE030A8C0FACA4FFB|DEPARTMENT_L_NAME|DEPARTMENT_L NAME|F0B5E976B5BA741CE030A8C0FACA4FFB|JOIN|JOIN|F0B5E976B663741CE030A8C0FACA4FFB|OUTGRP1|OUTGRP1|F0B5E976B668741CE030A8C0FACA4FFB|DNAME|DNAME|F0B5E976B676741CE030A8C0FACA4FFB
MAPPINGPARAMETERCONNECTION|EMPLOYEE_DIM|EMPLOYEE_DIM|F0B5E976B5AF741CE030A8C0FACA4FFB|INOUTGRP1|INOUTGRP1|F0B5E976B5B0741CE030A8C0FACA4FFB|EMPLOYEE_L_ID|EMPLOYEE_L ID|F0B5E976B5BC741CE030A8C0FACA4FFB|EMPLOYEE_DIM_SEQ|EMPLOYEE_DIM_SEQ|F0B5E976B5E0741CE030A8C0FACA4FFB|OUTGRP1|OUTGRP1|F0B5E976B5E1741CE030A8C0FACA4FFB|NEXTVAL|NEXTVAL|F0B5E976B5E8741CE030A8C0FACA4FFB
MAPPINGPARAMETERCONNECTION|EMPLOYEE_DIM|EMPLOYEE_DIM|F0B5E976B5AF741CE030A8C0FACA4FFB|INOUTGRP1|INOUTGRP1|F0B5E976B5B0741CE030A8C0FACA4FFB|EMPLOYEE_L_NAME|EMPLOYEE_L_NAME|F0B5E976B5BE741CE030A8C0FACA4FFB|JOIN|JOIN|F0B5E976B663741CE030A8C0FACA4FFB|OUTGRP1|OUTGRP1|F0B5E976B668741CE030A8C0FACA4FFB|ENAME|ENAME|F0B5E976B66D741CE030A8C0FACA4FFB
MAPPINGPARAMETERCONNECTION|EMPLOYEE_DIM|EMPLOYEE_DIM|F0B5E976B5AF741CE030A8C0FACA4FFB|INOUTGRP1|INOUTGRP1|F0B5E976B5B0741CE030A8C0FACA4FFB|TOTAL_L_NAME|TOTAL_L NAME|F0B5E976B5C0741CE030A8C0FACA4FFB|CONST|CONST|F0B5E976B5ED741CE030A8C0FACA4FFB|OUTGRP1|OUTGRP1|F0B5E976B5EE741CE030A8C0FACA4FFB|TOTAL|OUTPUT1|F0B5E976B5F1741CE030A8C0FACA4FFB
MAPPINGPARAMETERCONNECTION|JOIN|JOIN|F0B5E976B663741CE030A8C0FACA4FFB|INGRP1|INGRP1|F0B5E976B664741CE030A8C0FACA4FFB|ENAME|ENAME|F0B5E976B66C741CE030A8C0FACA4FFB|EMP|EMP|F0B5E976B61F741CE030A8C0FACA4FFB|INOUTGRP1|INOUTGRP1|F0B5E976B620741CE030A8C0FACA4FFB|ENAME|ENAME|F0B5E976B642741CE030A8C0FACA4FFB
MAPPINGPARAMETERCONNECTION|JOIN|JOIN|F0B5E976B663741CE030A8C0FACA4FFB|INGRP1|INGRP1|F0B5E976B664741CE030A8C0FACA4FFB|DEPTNO|DEPTNO|F0B5E976B66F741CE030A8C0FACA4FFB|EMP|EMP|F0B5E976B61F741CE030A8C0FACA4FFB|INOUTGRP1|INOUTGRP1|F0B5E976B620741CE030A8C0FACA4FFB|DEPTNO|DEPTNO|F0B5E976B64E741CE030A8C0FACA4FFB
MAPPINGPARAMETERCONNECTION|JOIN|JOIN|F0B5E976B663741CE030A8C0FACA4FFB|INGRP2|INGRP2|F0B5E976B666741CE030A8C0FACA4FFB|DEPTNO|DEPTNO|F0B5E976B671741CE030A8C0FACA4FFB|DEPT|DEPT|F0B5E976B5F6741CE030A8C0FACA4FFB|INOUTGRP1|INOUTGRP1|F0B5E976B5F7741CE030A8C0FACA4FFB|DEPTNO|DEPTNO|F0B5E976B60F741CE030A8C0FACA4FFB
MAPPINGPARAMETERCONNECTION|JOIN|JOIN|F0B5E976B663741CE030A8C0FACA4FFB|INGRP2|INGRP2|F0B5E976B666741CE030A8C0FACA4FFB|DNAME|DNAME|F0B5E976B675741CE030A8C0FACA4FFB|DEPT|DEPT|F0B5E976B5F6741CE030A8C0FACA4FFB|INOUTGRP1|INOUTGRP1|F0B5E976B5F7741CE030A8C0FACA4FFB|DNAME|DNAME|F0B5E976B611741CE030A8C0FACA4FFB
#
MAPPINGPHYSICALPROPERTY|8i.MAPPINGS.DEPLOYABLE|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
true
END_PROPERTYVALUE
#
MAPPINGPHYSICALPROPERTY|8i.MAPPINGS.STEPTYPE|STRING|0|F0B5E976B679741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
8i.MAPPINGS.PLSQLSTEP
END_PROPERTYVALUE
#
#
#Physical Mapping Step  <Type> <Name> <Universal ID>
PHYSICALMAPPINGSTEP|8i.MAPPINGS.PLSQLSTEP|Step0|F0B5E976B6B9741CE030A8C0FACA4FFB
PHYSICALMAPPINGSTEPPROPERTY|8i.MAPPINGS.PLSQLSTEP.RUNTIMEPARAMS.DEFAULTOPERATINGMODE|STRING|0|null
BEGIN_PROPERTYVALUE
SET_BASED_FAIL_OVER_TO_ROW_BASED
END_PROPERTYVALUE
#
PHYSICALMAPPINGSTEPPROPERTY|8i.MAPPINGS.PLSQLSTEP.RUNTIMEPARAMS.DEFAULTBULKSIZE|INTEGER|0|null
BEGIN_PROPERTYVALUE
50
END_PROPERTYVALUE
#
PHYSICALMAPPINGSTEPPROPERTY|8i.MAPPINGS.PLSQLSTEP.RUNTIMEPARAMS.DEFAULTAUDITLEVEL|STRING|0|null
BEGIN_PROPERTYVALUE
ERROR_DETAILS
END_PROPERTYVALUE
#
PHYSICALMAPPINGSTEPPROPERTY|8i.MAPPINGS.PLSQLSTEP.RUNTIMEPARAMS.DEFAULTMAXERRORS|INTEGER|0|null
BEGIN_PROPERTYVALUE
50
END_PROPERTYVALUE
#
PHYSICALMAPPINGSTEPPROPERTY|8i.MAPPINGS.PLSQLSTEP.RUNTIMEPARAMS.DEFAULTCOMMITFREQ|INTEGER|0|null
BEGIN_PROPERTYVALUE
1000
END_PROPERTYVALUE
#
PHYSICALMAPPINGSTEPPROPERTY|8i.MAPPINGS.PLSQLSTEP.RUNTIMEPARAMS.DEFAULTPURGEGROUP|STRING|0|null
BEGIN_PROPERTYVALUE
wb
END_PROPERTYVALUE
#
PHYSICALMAPPINGSTEPPROPERTY|8i.MAPPINGS.PLSQLSTEP.RUNTIMEPARAMS.DEFAULTANALYSISPERCENTAGE|INTEGER|0|null
BEGIN_PROPERTYVALUE
90
END_PROPERTYVALUE
#
PHYSICALMAPPINGSTEPPROPERTY|8i.MAPPINGS.PLSQLSTEP.CODEGENERATIONPARAMS.BULKMODE|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
true
END_PROPERTYVALUE
#
PHYSICALMAPPINGSTEPPROPERTY|8i.MAPPINGS.PLSQLSTEP.CODEGENERATIONPARAMS.DEFAULTTABLEFUNCTIONS|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
PHYSICALMAPPINGSTEPPROPERTY|8i.MAPPINGS.PLSQLSTEP.CODEGENERATIONPARAMS.GENERATEANALYZETABLE|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
true
END_PROPERTYVALUE
#
PHYSICALMAPPINGSTEPPROPERTY|8i.MAPPINGS.PLSQLSTEP.CODEGENERATIONPARAMS.OPTIMIZERMODE|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
true
END_PROPERTYVALUE
#
PHYSICALMAPPINGSTEPPROPERTY|8i.MAPPINGS.PLSQLSTEP.CODEGENERATIONPARAMS.USEHC|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
#
#Mapping  <PhysicalName> <LogicalName> <UniversalID> <ModulePhysicalName> <ModuleLogicalName> <ModuleUniversalID> <ModuleType>
MAPPING|LOAD_TIME_DIM_STEP1|LOAD_TIME_DIM_STEP1|F0B7BABAD8724CDCE030A8C0FACA52BB|OWB_TST|OWB_TST|F0B5E976B44A741CE030A8C0FACA4FFB|DATAWAREHOUSE
#
#Mapping Stage Component  <PhysicalName> <LogicalName> <UniversalID> <ComponentType> <ReferencedProjectPhysicalName> <ReferencedProjectLogicalName>
#     <ReferencedProjectUniversalID> <ReferencedModulePhysicalName> <ReferencedModuleLogicalName> <ReferencedModuleUniversalID> 
#     <ReferencedModuleType> <ReferencedCategoryPhysicalName> <ReferencedCategoryLogicalName> <ReferencedCategoryUniversalID>
#     <ReferencedEntityPhysicalName> <ReferencedEntityLogicalName> <ReferencedEntityUniversalID> <ReferencedEntityType> <ReferencedFunctionSignature>
MAPPINGSTAGECOMPONENT|CONST|CONST|F0B7BABAD8D34CDCE030A8C0FACA52BB|oracle.wh.service.impl.mapping.component.Variables|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null
#
#Mapping Property  <Key> <ValueType> <PropertyLevel> <UniversalID>
MAPPINGSTAGECOMPONENTPROPERTY|OWBINTERNAL.APPEARANCE|STRING|0|F0B7BABAD8D64CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
216|19|163|144|0|1
END_PROPERTYVALUE
#
#
#Mapping Stage Component Parameter Group  <PhysicalName> <LogicalName> <UniversalID> <Direction> <ReferencedProjectPhysicalName>
#     <ReferencedProjectLogicalName> <ReferencedProjectUniversalID> <ReferencedModulePhysicalName> <ReferencedModuleLogicalName> <ReferencedModuleUniversalID> 
#     <ReferencedModuleType> <ReferencedCategoryPhysicalName> <ReferencedCategoryLogicalName> <ReferencedCategoryUniversalID>
#     <ReferencedEntityPhysicalName> <ReferencedEntityLogicalName> <ReferencedEntityUniversalID> <ReferencedEntityType>
#     <CurrentDisplaySetPhysicalName> <CurrentDisplaySetLogicalName> <CurrentDisplaySetUniversalID> <CurrentDisplaySetType>
MAPPINGPARAMETERGROUP|OUTGRP1|OUTGRP1|F0B7BABAD8D44CDCE030A8C0FACA52BB|2|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|0
#
#Mapping Parameter  <PhysicalName> <LogicalName> <UniversalID> <DataType> <Length> <Precision> <Scale> <ReferencedItemPhysicalName> <ReferencedItemLogicalName> <ReferencedItemUniversalID>
MAPPINGPARAMETER|TOTAL|OUTPUT1|F0B7BABAD8D74CDCE030A8C0FACA52BB|VARCHAR2|10|0|0|null|null|null
BEGIN_EXPRESSION
'All'
END_EXPRESSION
#
MAPPINGSTAGECOMPONENT|EXPR|EXPR|F0B7BABAD8DA4CDCE030A8C0FACA52BB|oracle.wh.service.impl.mapping.component.ExpressionTransform|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null
#
#Mapping Property  <Key> <ValueType> <PropertyLevel> <UniversalID>
MAPPINGSTAGECOMPONENTPROPERTY|OWBINTERNAL.APPEARANCE|STRING|0|F0B7BABAD8DE4CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
335|307|200|214|0|0
END_PROPERTYVALUE
#
#
#Mapping Stage Component Parameter Group  <PhysicalName> <LogicalName> <UniversalID> <Direction> <ReferencedProjectPhysicalName>
#     <ReferencedProjectLogicalName> <ReferencedProjectUniversalID> <ReferencedModulePhysicalName> <ReferencedModuleLogicalName> <ReferencedModuleUniversalID> 
#     <ReferencedModuleType> <ReferencedCategoryPhysicalName> <ReferencedCategoryLogicalName> <ReferencedCategoryUniversalID>
#     <ReferencedEntityPhysicalName> <ReferencedEntityLogicalName> <ReferencedEntityUniversalID> <ReferencedEntityType>
#     <CurrentDisplaySetPhysicalName> <CurrentDisplaySetLogicalName> <CurrentDisplaySetUniversalID> <CurrentDisplaySetType>
MAPPINGPARAMETERGROUP|INGRP1|INGRP1|F0B7BABAD8DB4CDCE030A8C0FACA52BB|1|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|0
#
#Mapping Parameter  <PhysicalName> <LogicalName> <UniversalID> <DataType> <Length> <Precision> <Scale> <ReferencedItemPhysicalName> <ReferencedItemLogicalName> <ReferencedItemUniversalID>
MAPPINGPARAMETER|DATE_FORMAT|OUTPUT1|F0B7BABAD8DF4CDCE030A8C0FACA52BB|DATE|0|0|0|null|null|null
#
MAPPINGPARAMETERGROUP|OUTGRP1|OUTGRP1|F0B7BABAD8DC4CDCE030A8C0FACA52BB|2|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|0
#
#Mapping Parameter  <PhysicalName> <LogicalName> <UniversalID> <DataType> <Length> <Precision> <Scale> <ReferencedItemPhysicalName> <ReferencedItemLogicalName> <ReferencedItemUniversalID>
MAPPINGPARAMETER|CAL_QTR|OUTPUT1|F0B7BABAD8E14CDCE030A8C0FACA52BB|NUMBER|0|0|0|null|null|null
BEGIN_EXPRESSION
WB_CAL_QTR( &0 )
END_EXPRESSION
#
MAPPINGPARAMETER|CAL_YEAR|OUTPUT2|F0B7BABAD8E24CDCE030A8C0FACA52BB|NUMBER|0|0|0|null|null|null
BEGIN_EXPRESSION
WB_CAL_YEAR( &0)
END_EXPRESSION
#
MAPPINGSTAGECOMPONENT|TIME_DIM_SEQ|TIME_DIM_SEQ|F0B7BABAD8914CDCE030A8C0FACA52BB|oracle.wh.service.impl.mapping.component.Sequence|PSOUG_FEB23|PSOUG_FEB23|F0B5E976B448741CE030A8C0FACA4FFB|OWB_TST|OWB_TST|F0B5E976B44A741CE030A8C0FACA4FFB|DATAWAREHOUSE|null|null|null|TIME_DIM_SEQ|TIME_DIM_SEQ|F0B5E976B44C741CE030A8C0FACA4FFB|SEQUENCE|null
#
#Mapping Property  <Key> <ValueType> <PropertyLevel> <UniversalID>
MAPPINGSTAGECOMPONENTPROPERTY|MAPPING.BOUNDNAME|STRING|0|F0B7BABAD8984CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
TIME_DIM_SEQ
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|OWBINTERNAL.APPEARANCE|STRING|0|F0B7BABAD8974CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
319|20|171|168|0|1
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.SCHEMA|STRING|0|F0B7BABAD8964CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.DBLINK|STRING|0|F0B7BABAD8954CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.METADATA.NEW|STRING|0|F0B7BABAD89C4CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
Y
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.METADATA.DBLINK|STRING|0|F0B7BABAD8944CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.OWNER.IM|STRING|0|F0B7BABAD89B4CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
OWB_TST
END_PROPERTYVALUE
#
#
#Mapping Stage Component Parameter Group  <PhysicalName> <LogicalName> <UniversalID> <Direction> <ReferencedProjectPhysicalName>
#     <ReferencedProjectLogicalName> <ReferencedProjectUniversalID> <ReferencedModulePhysicalName> <ReferencedModuleLogicalName> <ReferencedModuleUniversalID> 
#     <ReferencedModuleType> <ReferencedCategoryPhysicalName> <ReferencedCategoryLogicalName> <ReferencedCategoryUniversalID>
#     <ReferencedEntityPhysicalName> <ReferencedEntityLogicalName> <ReferencedEntityUniversalID> <ReferencedEntityType>
#     <CurrentDisplaySetPhysicalName> <CurrentDisplaySetLogicalName> <CurrentDisplaySetUniversalID> <CurrentDisplaySetType>
MAPPINGPARAMETERGROUP|OUTGRP1|OUTGRP1|F0B7BABAD8924CDCE030A8C0FACA52BB|2|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|0
#
#Mapping Parameter  <PhysicalName> <LogicalName> <UniversalID> <DataType> <Length> <Precision> <Scale> <ReferencedItemPhysicalName> <ReferencedItemLogicalName> <ReferencedItemUniversalID>
MAPPINGPARAMETER|NEXTVAL|NEXTVAL|F0B7BABAD8994CDCE030A8C0FACA52BB|NUMBER|0|0|0|NEXTVAL|NEXTVAL|F0B5E976B44D741CE030A8C0FACA4FFB
BEGIN_EXPRESSION
"TIME_DIM_SEQ".NEXTVAL
END_EXPRESSION
#
MAPPINGPARAMETER|CURRVAL|CURRVAL|F0B7BABAD89A4CDCE030A8C0FACA52BB|NUMBER|0|0|0|CURRVAL|CURRVAL|F0B5E976B44E741CE030A8C0FACA4FFB
BEGIN_EXPRESSION
"TIME_DIM_SEQ".CURRVAL
END_EXPRESSION
#
MAPPINGSTAGECOMPONENT|TIME_DIM|TIME_DIM|F0B7BABAD89D4CDCE030A8C0FACA52BB|oracle.wh.service.impl.mapping.component.Dimension|PSOUG_FEB23|PSOUG_FEB23|F0B5E976B448741CE030A8C0FACA4FFB|OWB_TST|OWB_TST|F0B5E976B44A741CE030A8C0FACA4FFB|DATAWAREHOUSE|null|null|null|TIME_DIM|TIME_DIM|F0B5E976B48C741CE030A8C0FACA4FFB|DIMENSION|null
#
#Mapping Property  <Key> <ValueType> <PropertyLevel> <UniversalID>
MAPPINGSTAGECOMPONENTPROPERTY|MAPPING.BOUNDNAME|STRING|0|F0B7BABAD8B44CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
TIME_DIM
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.DEFAULT.PRIMARY_SOURCE|STRING|0|null
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.PARMETERS.LOADTYPE|STRING|0|null
BEGIN_PROPERTYVALUE
INSERT
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.PARMETERS.UPDATETARGETCONDITION|STRING|0|null
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.PARMETERS.DELETETARGETCONDITION|STRING|0|null
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.PARMETERS.MATCHBYCONSTRAINT|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.PARMETERS.ADVANCEDMATCHBYCONSTRAINT|STRING|0|null
BEGIN_PROPERTYVALUE
No constraints
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.KEYS|STRING|0|F0B7BABAD8AD4CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
UKEY_PROPERTY_PARENT0
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.KEY.NAME|STRING|1|F0B7BABAD8B34CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
TIME_DIM_CAL_DATE_L_UK
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.KEY.ID|STRING|1|F0B7BABAD8B24CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
1
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.KEY.RECONCILEUOID|STRING|1|F0B7BABAD8B14CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
F0B5E976B49D741CE030A8C0FACA4FFB
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.KEY.KEYCOLUMNS|STRING|1|F0B7BABAD8B04CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
&0
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.KEY.KEYTYPE|STRING|1|null
BEGIN_PROPERTYVALUE
UNIQUE
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.KEY.REFERENCEDKEYS|STRING|1|F0B7BABAD8AF4CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.KEY.REFERENCED_RECONCILEUOIDS|STRING|1|F0B7BABAD8AE4CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|OWBINTERNAL.APPEARANCE|STRING|0|F0B7BABAD8AC4CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
660|134|229|237|0|0
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.SCHEMA|STRING|0|F0B7BABAD8AB4CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.DBLINK|STRING|0|F0B7BABAD8AA4CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.METADATA.NEW|STRING|0|F0B7BABAD8C64CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
Y
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.METADATA.DBLINK|STRING|0|F0B7BABAD8A94CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.OWNER.IM|STRING|0|F0B7BABAD8C54CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
OWB_TST
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.USEPEL|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.PARTITIONGRANULARITY|STRING|0|null
BEGIN_PROPERTYVALUE
UNKNOWN
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.DIRECTPEL|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.IGNOREEXISTINGDATA|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.EXTRACT_HINT|STRING|0|F0B7BABAD8A84CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.LOAD_HINT|STRING|0|F0B7BABAD8A74CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
APPEND PARALLEL(<TABLE_ALIAS>, DEFAULT, DEFAULT)
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.REENABLECONSTRAINTS|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
true
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.EXCEPTIONS|STRING|0|F0B7BABAD8A64CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.PARTITIONNAME|STRING|0|F0B7BABAD8A54CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.SUBPARTITIONNAME|STRING|0|F0B7BABAD8A44CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.SORTEDINDEXES|STRING|0|F0B7BABAD8A34CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.SINGLEROW|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.TRAILINGNULLCOLS|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.SKIP|INTEGER|0|null
BEGIN_PROPERTYVALUE
0
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.FILE|STRING|0|F0B7BABAD8A24CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SAPTABLE.TABLETYPE|STRING|0|F0B7BABAD8A14CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SAPTABLE.EXTRACTIONMETHOD|STRING|0|F0B7BABAD8A04CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
#
#Mapping Stage Component Parameter Group  <PhysicalName> <LogicalName> <UniversalID> <Direction> <ReferencedProjectPhysicalName>
#     <ReferencedProjectLogicalName> <ReferencedProjectUniversalID> <ReferencedModulePhysicalName> <ReferencedModuleLogicalName> <ReferencedModuleUniversalID> 
#     <ReferencedModuleType> <ReferencedCategoryPhysicalName> <ReferencedCategoryLogicalName> <ReferencedCategoryUniversalID>
#     <ReferencedEntityPhysicalName> <ReferencedEntityLogicalName> <ReferencedEntityUniversalID> <ReferencedEntityType>
#     <CurrentDisplaySetPhysicalName> <CurrentDisplaySetLogicalName> <CurrentDisplaySetUniversalID> <CurrentDisplaySetType>
MAPPINGPARAMETERGROUP|INOUTGRP1|INOUTGRP1|F0B7BABAD89E4CDCE030A8C0FACA52BB|3|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|0
#
#Mapping Parameter  <PhysicalName> <LogicalName> <UniversalID> <DataType> <Length> <Precision> <Scale> <ReferencedItemPhysicalName> <ReferencedItemLogicalName> <ReferencedItemUniversalID>
MAPPINGPARAMETER|CAL_DATE_L_ID|CAL_DATE_L ID|F0B7BABAD8B54CDCE030A8C0FACA52BB|NUMBER|0|0|0|CAL_DATE_L_ID|CAL_DATE_L ID|F0B5E976B49F741CE030A8C0FACA4FFB
BEGIN_EXPRESSION
"TIME_DIM"."CAL_DATE_L_ID"
END_EXPRESSION
MAPPINGPARAMETERPROPERTY|MAPPING.BOUNDNAME|STRING|0|F0B7BABAD8B64CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
CAL_DATE_L_ID
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.INSERTLOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATELOADING|STRING|0|F0B7BABAD8C94CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEMATCHING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEOPERATION|STRING|0|null
BEGIN_PROPERTYVALUE
=
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.DELETEMATCHING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
#
MAPPINGPARAMETER|CAL_DATE_L_NAME|CAL_DATE_L_NAME|F0B7BABAD8B74CDCE030A8C0FACA52BB|DATE|0|0|0|CAL_DATE_L_NAME|CAL_DATE_L_NAME|F0B5E976B4AA741CE030A8C0FACA4FFB
BEGIN_EXPRESSION
"TIME_DIM"."CAL_DATE_L_NAME"
END_EXPRESSION
MAPPINGPARAMETERPROPERTY|MAPPING.BOUNDNAME|STRING|0|F0B7BABAD8B84CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
CAL_DATE_L_NAME
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.INSERTLOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATELOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEMATCHING|STRING|0|F0B7BABAD8CB4CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEOPERATION|STRING|0|null
BEGIN_PROPERTYVALUE
=
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.DELETEMATCHING|STRING|0|F0B7BABAD8CA4CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
#
MAPPINGPARAMETER|CAL_QTR_L_ID|CAL_QTR_L ID|F0B7BABAD8B94CDCE030A8C0FACA52BB|NUMBER|0|0|0|CAL_QTR_L_ID|CAL_QTR_L ID|F0B5E976B498741CE030A8C0FACA4FFB
BEGIN_EXPRESSION
"TIME_DIM"."CAL_QTR_L_ID"
END_EXPRESSION
MAPPINGPARAMETERPROPERTY|MAPPING.BOUNDNAME|STRING|0|F0B7BABAD8BA4CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
CAL_QTR_L_ID
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.INSERTLOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATELOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEMATCHING|STRING|0|F0B7BABAD8CD4CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEOPERATION|STRING|0|null
BEGIN_PROPERTYVALUE
=
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.DELETEMATCHING|STRING|0|F0B7BABAD8CC4CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
#
MAPPINGPARAMETER|CAL_YEAR_L_ID|CAL_YEAR_L ID|F0B7BABAD8BB4CDCE030A8C0FACA52BB|NUMBER|0|0|0|CAL_YEAR_L_ID|CAL_YEAR_L ID|F0B5E976B491741CE030A8C0FACA4FFB
BEGIN_EXPRESSION
"TIME_DIM"."CAL_YEAR_L_ID"
END_EXPRESSION
MAPPINGPARAMETERPROPERTY|MAPPING.BOUNDNAME|STRING|0|F0B7BABAD8BC4CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
CAL_YEAR_L_ID
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.INSERTLOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATELOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEMATCHING|STRING|0|F0B7BABAD8CF4CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEOPERATION|STRING|0|null
BEGIN_PROPERTYVALUE
=
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.DELETEMATCHING|STRING|0|F0B7BABAD8CE4CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
#
MAPPINGPARAMETER|TOTAL_L_NAME|TOTAL_L NAME|F0B7BABAD8BD4CDCE030A8C0FACA52BB|VARCHAR2|10|0|0|TOTAL_L_NAME|TOTAL_L NAME|F0B5E976B4A6741CE030A8C0FACA4FFB
BEGIN_EXPRESSION
"TIME_DIM"."TOTAL_L_NAME"
END_EXPRESSION
MAPPINGPARAMETERPROPERTY|MAPPING.BOUNDNAME|STRING|0|F0B7BABAD8BE4CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
TOTAL_L_NAME
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.INSERTLOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATELOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEMATCHING|STRING|0|F0B7BABAD8D14CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEOPERATION|STRING|0|null
BEGIN_PROPERTYVALUE
=
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.DELETEMATCHING|STRING|0|F0B7BABAD8D04CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
#
#Mapping Display Set  <PhysicalName> <LogicalName> <UniversalID> <ReferencedAttrSetPhysicalName> <ReferencedAttrSetName> <ReferencedAttrSetUniversalID>
MAPPINGDISPLAYSET|CALENDARY_H|CALENDARY_H|F0B7BABAD8BF4CDCE030A8C0FACA52BB|CALENDARY_H|CALENDARY_H|F0B5E976B4AC741CE030A8C0FACA4FFB
MAPPINGDISPLAYSETPARAMETER|CAL_DATE_L_NAME|CAL_DATE_L_NAME|F0B7BABAD8B74CDCE030A8C0FACA52BB
MAPPINGDISPLAYSETPARAMETER|TOTAL_L_NAME|TOTAL_L NAME|F0B7BABAD8BD4CDCE030A8C0FACA52BB
MAPPINGDISPLAYSETPARAMETER|CAL_QTR_L_ID|CAL_QTR_L ID|F0B7BABAD8B94CDCE030A8C0FACA52BB
MAPPINGDISPLAYSETPARAMETER|CAL_YEAR_L_ID|CAL_YEAR_L ID|F0B7BABAD8BB4CDCE030A8C0FACA52BB
MAPPINGDISPLAYSETPARAMETER|CAL_DATE_L_ID|CAL_DATE_L ID|F0B7BABAD8B54CDCE030A8C0FACA52BB
#
MAPPINGSTAGECOMPONENT|PAY_DATA_STG|PAY_DATA_STG|F0B7BABAD8734CDCE030A8C0FACA52BB|oracle.wh.service.impl.mapping.component.Table|PSOUG_FEB23|PSOUG_FEB23|F0B5E976B448741CE030A8C0FACA4FFB|OWB_TST|OWB_TST|F0B5E976B44A741CE030A8C0FACA4FFB|DATAWAREHOUSE|null|null|null|PAY_DATA_STG|PAY_DATA_STG|F0B5E976B7DC741CE030A8C0FACA4FFB|TABLE|null
#
#Mapping Property  <Key> <ValueType> <PropertyLevel> <UniversalID>
MAPPINGSTAGECOMPONENTPROPERTY|MAPPING.BOUNDNAME|STRING|0|F0B7BABAD8764CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
PAY_DATA_STG
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.DEFAULT.PRIMARY_SOURCE|STRING|0|null
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.PARMETERS.LOADTYPE|STRING|0|null
BEGIN_PROPERTYVALUE
INSERT
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.PARMETERS.UPDATETARGETCONDITION|STRING|0|null
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.PARMETERS.DELETETARGETCONDITION|STRING|0|null
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.PARMETERS.MATCHBYCONSTRAINT|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.PARMETERS.ADVANCEDMATCHBYCONSTRAINT|STRING|0|null
BEGIN_PROPERTYVALUE
No constraints
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|OWBINTERNAL.APPEARANCE|STRING|0|F0B7BABAD8754CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
31|199|200|190|0|0
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.SCHEMA|STRING|0|F0B7BABAD88A4CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.DBLINK|STRING|0|F0B7BABAD8894CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.METADATA.NEW|STRING|0|F0B7BABAD8884CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
Y
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.METADATA.DBLINK|STRING|0|F0B7BABAD8874CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.OWNER.IM|STRING|0|F0B7BABAD8864CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
OWB_TST
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.USEPEL|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.PARTITIONGRANULARITY|STRING|0|null
BEGIN_PROPERTYVALUE
UNKNOWN
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.DIRECTPEL|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.IGNOREEXISTINGDATA|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.EXTRACT_HINT|STRING|0|F0B7BABAD8854CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.LOAD_HINT|STRING|0|F0B7BABAD8844CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
APPEND PARALLEL(<TABLE_ALIAS>, DEFAULT, DEFAULT)
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.REENABLECONSTRAINTS|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
true
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.EXCEPTIONS|STRING|0|F0B7BABAD8834CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.PARTITIONNAME|STRING|0|F0B7BABAD8824CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.SUBPARTITIONNAME|STRING|0|F0B7BABAD8814CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.SORTEDINDEXES|STRING|0|F0B7BABAD8804CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.SINGLEROW|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.TRAILINGNULLCOLS|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.SKIP|INTEGER|0|null
BEGIN_PROPERTYVALUE
0
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.FILE|STRING|0|F0B7BABAD87F4CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SAPTABLE.TABLETYPE|STRING|0|F0B7BABAD87E4CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SAPTABLE.EXTRACTIONMETHOD|STRING|0|F0B7BABAD87D4CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
#
#Mapping Stage Component Parameter Group  <PhysicalName> <LogicalName> <UniversalID> <Direction> <ReferencedProjectPhysicalName>
#     <ReferencedProjectLogicalName> <ReferencedProjectUniversalID> <ReferencedModulePhysicalName> <ReferencedModuleLogicalName> <ReferencedModuleUniversalID> 
#     <ReferencedModuleType> <ReferencedCategoryPhysicalName> <ReferencedCategoryLogicalName> <ReferencedCategoryUniversalID>
#     <ReferencedEntityPhysicalName> <ReferencedEntityLogicalName> <ReferencedEntityUniversalID> <ReferencedEntityType>
#     <CurrentDisplaySetPhysicalName> <CurrentDisplaySetLogicalName> <CurrentDisplaySetUniversalID> <CurrentDisplaySetType>
MAPPINGPARAMETERGROUP|INOUTGRP1|INOUTGRP1|F0B7BABAD8744CDCE030A8C0FACA52BB|3|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|0
#
#Mapping Parameter  <PhysicalName> <LogicalName> <UniversalID> <DataType> <Length> <Precision> <Scale> <ReferencedItemPhysicalName> <ReferencedItemLogicalName> <ReferencedItemUniversalID>
MAPPINGPARAMETER|PAYROLLID|PayrollID|F0B7BABAD8774CDCE030A8C0FACA52BB|NUMBER|0|0|0|PAYROLLID|PayrollID|F0B5E976B7FC741CE030A8C0FACA4FFB
BEGIN_EXPRESSION
"PAY_DATA_STG"."PAYROLLID"
END_EXPRESSION
MAPPINGPARAMETERPROPERTY|MAPPING.BOUNDNAME|STRING|0|F0B7BABAD8784CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
PAYROLLID
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.INSERTLOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATELOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEMATCHING|STRING|0|F0B7BABAD88E4CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEOPERATION|STRING|0|null
BEGIN_PROPERTYVALUE
=
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.DELETEMATCHING|STRING|0|F0B7BABAD88D4CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
#
MAPPINGPARAMETER|DATE_FORMAT|OUTPUT1|F0B7BABAD8794CDCE030A8C0FACA52BB|DATE|0|0|0|DATE_FORMAT|OUTPUT1|F0B5E976B7FD741CE030A8C0FACA4FFB
BEGIN_EXPRESSION
"PAY_DATA_STG"."DATE_FORMAT"
END_EXPRESSION
MAPPINGPARAMETERPROPERTY|MAPPING.BOUNDNAME|STRING|0|F0B7BABAD87A4CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
DATE_FORMAT
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.INSERTLOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATELOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEMATCHING|STRING|0|F0B7BABAD8904CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEOPERATION|STRING|0|null
BEGIN_PROPERTYVALUE
=
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.DELETEMATCHING|STRING|0|F0B7BABAD88F4CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
#
#Mapping Parameter Connection  <TargetStageComponentPhysicalName>  <TargetStageComponentLogicalName> <TargetStageComponentUniversalID>
#     <TargetParameterGroupPhysicalName>  <TargetParameterGroupLogicalName> <TargetParameterGroupUniversalID>
#     <TargetParameterPhysicalName> <TargetParameterLogicalName> <TargetParameterUniversalID> <SourceStageComponentPhysicalName>
#     <SourceStageComponentLogicalName> <SourceStageComponentUniversalID> <SourceParameterGroupPhysicalName> <SourceParameterGroupLogicalName>
#     <SourceParameterGroupUniversalID> <SourceParameterPhysicalName> <SourceParameterLogicalName> <SourceParameterUniversalID>
MAPPINGPARAMETERCONNECTION|EXPR|EXPR|F0B7BABAD8DA4CDCE030A8C0FACA52BB|INGRP1|INGRP1|F0B7BABAD8DB4CDCE030A8C0FACA52BB|DATE_FORMAT|OUTPUT1|F0B7BABAD8DF4CDCE030A8C0FACA52BB|PAY_DATA_STG|PAY_DATA_STG|F0B7BABAD8734CDCE030A8C0FACA52BB|INOUTGRP1|INOUTGRP1|F0B7BABAD8744CDCE030A8C0FACA52BB|DATE_FORMAT|OUTPUT1|F0B7BABAD8794CDCE030A8C0FACA52BB
MAPPINGPARAMETERCONNECTION|TIME_DIM|TIME_DIM|F0B7BABAD89D4CDCE030A8C0FACA52BB|INOUTGRP1|INOUTGRP1|F0B7BABAD89E4CDCE030A8C0FACA52BB|CAL_DATE_L_ID|CAL_DATE_L ID|F0B7BABAD8B54CDCE030A8C0FACA52BB|TIME_DIM_SEQ|TIME_DIM_SEQ|F0B7BABAD8914CDCE030A8C0FACA52BB|OUTGRP1|OUTGRP1|F0B7BABAD8924CDCE030A8C0FACA52BB|NEXTVAL|NEXTVAL|F0B7BABAD8994CDCE030A8C0FACA52BB
MAPPINGPARAMETERCONNECTION|TIME_DIM|TIME_DIM|F0B7BABAD89D4CDCE030A8C0FACA52BB|INOUTGRP1|INOUTGRP1|F0B7BABAD89E4CDCE030A8C0FACA52BB|CAL_DATE_L_NAME|CAL_DATE_L_NAME|F0B7BABAD8B74CDCE030A8C0FACA52BB|PAY_DATA_STG|PAY_DATA_STG|F0B7BABAD8734CDCE030A8C0FACA52BB|INOUTGRP1|INOUTGRP1|F0B7BABAD8744CDCE030A8C0FACA52BB|DATE_FORMAT|OUTPUT1|F0B7BABAD8794CDCE030A8C0FACA52BB
MAPPINGPARAMETERCONNECTION|TIME_DIM|TIME_DIM|F0B7BABAD89D4CDCE030A8C0FACA52BB|INOUTGRP1|INOUTGRP1|F0B7BABAD89E4CDCE030A8C0FACA52BB|CAL_QTR_L_ID|CAL_QTR_L ID|F0B7BABAD8B94CDCE030A8C0FACA52BB|EXPR|EXPR|F0B7BABAD8DA4CDCE030A8C0FACA52BB|OUTGRP1|OUTGRP1|F0B7BABAD8DC4CDCE030A8C0FACA52BB|CAL_QTR|OUTPUT1|F0B7BABAD8E14CDCE030A8C0FACA52BB
MAPPINGPARAMETERCONNECTION|TIME_DIM|TIME_DIM|F0B7BABAD89D4CDCE030A8C0FACA52BB|INOUTGRP1|INOUTGRP1|F0B7BABAD89E4CDCE030A8C0FACA52BB|CAL_YEAR_L_ID|CAL_YEAR_L ID|F0B7BABAD8BB4CDCE030A8C0FACA52BB|EXPR|EXPR|F0B7BABAD8DA4CDCE030A8C0FACA52BB|OUTGRP1|OUTGRP1|F0B7BABAD8DC4CDCE030A8C0FACA52BB|CAL_YEAR|OUTPUT2|F0B7BABAD8E24CDCE030A8C0FACA52BB
MAPPINGPARAMETERCONNECTION|TIME_DIM|TIME_DIM|F0B7BABAD89D4CDCE030A8C0FACA52BB|INOUTGRP1|INOUTGRP1|F0B7BABAD89E4CDCE030A8C0FACA52BB|TOTAL_L_NAME|TOTAL_L NAME|F0B7BABAD8BD4CDCE030A8C0FACA52BB|CONST|CONST|F0B7BABAD8D34CDCE030A8C0FACA52BB|OUTGRP1|OUTGRP1|F0B7BABAD8D44CDCE030A8C0FACA52BB|TOTAL|OUTPUT1|F0B7BABAD8D74CDCE030A8C0FACA52BB
#
MAPPINGPHYSICALPROPERTY|8i.MAPPINGS.DEPLOYABLE|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
true
END_PROPERTYVALUE
#
MAPPINGPHYSICALPROPERTY|8i.MAPPINGS.STEPTYPE|STRING|0|F0B7BABAD8E64CDCE030A8C0FACA52BB
BEGIN_PROPERTYVALUE
8i.MAPPINGS.PLSQLSTEP
END_PROPERTYVALUE
#
#
#Physical Mapping Step  <Type> <Name> <Universal ID>
PHYSICALMAPPINGSTEP|8i.MAPPINGS.PLSQLSTEP|Step0|F0B7BABAD91D4CDCE030A8C0FACA52BB
PHYSICALMAPPINGSTEPPROPERTY|8i.MAPPINGS.PLSQLSTEP.RUNTIMEPARAMS.DEFAULTOPERATINGMODE|STRING|0|null
BEGIN_PROPERTYVALUE
SET_BASED_FAIL_OVER_TO_ROW_BASED
END_PROPERTYVALUE
#
PHYSICALMAPPINGSTEPPROPERTY|8i.MAPPINGS.PLSQLSTEP.RUNTIMEPARAMS.DEFAULTBULKSIZE|INTEGER|0|null
BEGIN_PROPERTYVALUE
50
END_PROPERTYVALUE
#
PHYSICALMAPPINGSTEPPROPERTY|8i.MAPPINGS.PLSQLSTEP.RUNTIMEPARAMS.DEFAULTAUDITLEVEL|STRING|0|null
BEGIN_PROPERTYVALUE
ERROR_DETAILS
END_PROPERTYVALUE
#
PHYSICALMAPPINGSTEPPROPERTY|8i.MAPPINGS.PLSQLSTEP.RUNTIMEPARAMS.DEFAULTMAXERRORS|INTEGER|0|null
BEGIN_PROPERTYVALUE
50
END_PROPERTYVALUE
#
PHYSICALMAPPINGSTEPPROPERTY|8i.MAPPINGS.PLSQLSTEP.RUNTIMEPARAMS.DEFAULTCOMMITFREQ|INTEGER|0|null
BEGIN_PROPERTYVALUE
1000
END_PROPERTYVALUE
#
PHYSICALMAPPINGSTEPPROPERTY|8i.MAPPINGS.PLSQLSTEP.RUNTIMEPARAMS.DEFAULTPURGEGROUP|STRING|0|null
BEGIN_PROPERTYVALUE
wb
END_PROPERTYVALUE
#
PHYSICALMAPPINGSTEPPROPERTY|8i.MAPPINGS.PLSQLSTEP.RUNTIMEPARAMS.DEFAULTANALYSISPERCENTAGE|INTEGER|0|null
BEGIN_PROPERTYVALUE
90
END_PROPERTYVALUE
#
PHYSICALMAPPINGSTEPPROPERTY|8i.MAPPINGS.PLSQLSTEP.CODEGENERATIONPARAMS.BULKMODE|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
true
END_PROPERTYVALUE
#
PHYSICALMAPPINGSTEPPROPERTY|8i.MAPPINGS.PLSQLSTEP.CODEGENERATIONPARAMS.DEFAULTTABLEFUNCTIONS|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
PHYSICALMAPPINGSTEPPROPERTY|8i.MAPPINGS.PLSQLSTEP.CODEGENERATIONPARAMS.GENERATEANALYZETABLE|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
true
END_PROPERTYVALUE
#
PHYSICALMAPPINGSTEPPROPERTY|8i.MAPPINGS.PLSQLSTEP.CODEGENERATIONPARAMS.OPTIMIZERMODE|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
true
END_PROPERTYVALUE
#
PHYSICALMAPPINGSTEPPROPERTY|8i.MAPPINGS.PLSQLSTEP.CODEGENERATIONPARAMS.USEHC|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
#
#Mapping  <PhysicalName> <LogicalName> <UniversalID> <ModulePhysicalName> <ModuleLogicalName> <ModuleUniversalID> <ModuleType>
MAPPING|LOAD_PAYROLL_DATA_STEP1|LOAD_PAYROLL_DATA_STEP1|F0B5E976B7A7741CE030A8C0FACA4FFB|OWB_TST|OWB_TST|F0B5E976B44A741CE030A8C0FACA4FFB|DATAWAREHOUSE
#
#Mapping Stage Component  <PhysicalName> <LogicalName> <UniversalID> <ComponentType> <ReferencedProjectPhysicalName> <ReferencedProjectLogicalName>
#     <ReferencedProjectUniversalID> <ReferencedModulePhysicalName> <ReferencedModuleLogicalName> <ReferencedModuleUniversalID> 
#     <ReferencedModuleType> <ReferencedCategoryPhysicalName> <ReferencedCategoryLogicalName> <ReferencedCategoryUniversalID>
#     <ReferencedEntityPhysicalName> <ReferencedEntityLogicalName> <ReferencedEntityUniversalID> <ReferencedEntityType> <ReferencedFunctionSignature>
MAPPINGSTAGECOMPONENT|PAY_DATA_STG|PAY_DATA_STG|F0B5E976B7DD741CE030A8C0FACA4FFB|oracle.wh.service.impl.mapping.component.Table|PSOUG_FEB23|PSOUG_FEB23|F0B5E976B448741CE030A8C0FACA4FFB|OWB_TST|OWB_TST|F0B5E976B44A741CE030A8C0FACA4FFB|DATAWAREHOUSE|null|null|null|PAY_DATA_STG|PAY_DATA_STG|F0B5E976B7DC741CE030A8C0FACA4FFB|TABLE|null
#
#Mapping Property  <Key> <ValueType> <PropertyLevel> <UniversalID>
MAPPINGSTAGECOMPONENTPROPERTY|MAPPING.BOUNDNAME|STRING|0|F0B5E976B7ED741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
PAY_DATA_STG
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.DEFAULT.PRIMARY_SOURCE|STRING|0|null
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.PARMETERS.LOADTYPE|STRING|0|null
BEGIN_PROPERTYVALUE
INSERT
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.PARMETERS.UPDATETARGETCONDITION|STRING|0|null
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.PARMETERS.DELETETARGETCONDITION|STRING|0|null
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.PARMETERS.MATCHBYCONSTRAINT|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.PARMETERS.ADVANCEDMATCHBYCONSTRAINT|STRING|0|null
BEGIN_PROPERTYVALUE
No constraints
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|OWBINTERNAL.APPEARANCE|STRING|0|F0B5E976B7EC741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
514|86|175|166|0|0
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.SCHEMA|STRING|0|F0B5E976B7EB741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.DBLINK|STRING|0|F0B5E976B7EA741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.METADATA.NEW|STRING|0|F0B5E976B7EF741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
Y
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.METADATA.DBLINK|STRING|0|F0B5E976B7E9741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.OWNER.IM|STRING|0|F0B5E976B7EE741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
OWB_TST
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.USEPEL|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.PARTITIONGRANULARITY|STRING|0|null
BEGIN_PROPERTYVALUE
UNKNOWN
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.DIRECTPEL|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.IGNOREEXISTINGDATA|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.EXTRACT_HINT|STRING|0|F0B5E976B7E8741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.LOAD_HINT|STRING|0|F0B5E976B7E7741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
APPEND PARALLEL(<TABLE_ALIAS>, DEFAULT, DEFAULT)
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.REENABLECONSTRAINTS|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
true
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.EXCEPTIONS|STRING|0|F0B5E976B7E6741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.PARTITIONNAME|STRING|0|F0B5E976B7E5741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.SUBPARTITIONNAME|STRING|0|F0B5E976B7E4741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.SORTEDINDEXES|STRING|0|F0B5E976B7E3741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.SINGLEROW|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.TRAILINGNULLCOLS|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.SKIP|INTEGER|0|null
BEGIN_PROPERTYVALUE
0
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.FILE|STRING|0|F0B5E976B7E2741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SAPTABLE.TABLETYPE|STRING|0|F0B5E976B7E1741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SAPTABLE.EXTRACTIONMETHOD|STRING|0|F0B5E976B7E0741CE030A8C0FACA4FFB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
#
#Mapping Stage Component Parameter Group  <PhysicalName> <LogicalName> <UniversalID> <Direction> <ReferencedProjectPhysicalName>
#     <ReferencedProjectLogicalName> <ReferencedProjectUniversalID> <ReferencedModuleP