Siebel Business Analytics Applications Installation and Administration Guide > Customizing the Siebel Data Warehouse > Siebel Data Warehouse ETL Process Concepts >

Working with the Custom Folder of the Siebel Data Warehouse

The Siebel Data Warehouse provides a folder within the repository specifically designed for customized changes to an implementation. This folder is named CUSTOM_DW_REP. Using the Informatica Designer, make modifications only in the CUSTOM_DW_REP folder.

Do not change objects in the SIEBEL_DW_REP folder unless it is explicitly mentioned. This folder may be overwritten in future upgrades. All changes should be placed in the CUSTOM_DW_REP folder within the Informatica Designer.

The easiest way to modify an object is to copy an existing object from SIEBEL_DW_REP into CUSTOM_DW_REP and to reuse existing business components, source and target definitions, transformations, mapplets, and mappings before you make any changes.

NOTE:  If source tables are extended (after copying into the CUSTOM_DW_REP folder), then the source tables require manual editing in the Informatica Designer. Do not import the tables from the database, because it changes the source table definitions for the entire Siebel Data Warehouse.

When importing new tables from the database into the CUSTOM_DW_REP folder, use the Siebel Data Warehouse and Siebel Transaction Database ODBC database connections to connect to the source and target databases.

After importing new table definitions, change the database type to Oracle in the Informatica repository, regardless of the database platform you are using. This has no effect on the choice of a relational database. This step is very important because in Informatica if the database type of the source tables are not identical, all mappings and workflows that refer to the source tables will be invalid.