In the beginning of BI project implementation I had this question:
Should I import all source database (Oracle schema) table metadata to Oracle Warehouse Builder? Or, just tables needed at this moment of implementation?
The answer is YES! You should import all tables from source database (Oracle schema). Why? Because BI system eventually should be used ant expanded by customer itself. Not by software development team, which was hired to develop project. By adding all tables from schema, you save yourself from running at client’s place and adding one by one table each time he wants to add extra column to fact or dimension.
When all database tables are in Warehouse Builder, then customer can add the same extra column to dimension or fact by it self.