Bookshelf Home | Contents | Index | Search | PDF

Siebel Data Warehouse Installation and Administration Guide > Extending the Siebel Data Warehouse > ETL Process Description >

Working With the Custom Folder

---

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

You should never add, modify, or delete any objects in the Siebel_DW_Rep folder. This folder may be overwritten in future upgrades. All changes should be placed in the Custom_DW_Rep folder within Informatica Designer.
The easiest way to modify an object is to copy an existing object from Siebel_DW_Rep into Custom_DW_Rep to reuse existing business components, source and target definitions, transformations, mapplets, or mappings before you make any changes.
If you must extend source tables (after copying into the Custom_DW_Rep folder), then you must manually edit the source table in Informatica Designer. Do not import from the database as it changes the source table definitions for the entire Siebel Data Warehouse.
If you are importing new tables from the database into the Custom_DW_Rep folder, then use the Siebel Data Warehouse and Siebel Transaction Database ODBC database connections to connect to the source and target databases.
After importing your new table definitions, change the database type to Oracle in the Informatica repository, regardless of your database platform. This has no effect on your choice of relational database.

Bookshelf Home | Contents | Index | Search | PDF