Hello, I am currently studying an 'Database' module which requires us to transform 3 databases into a single data warehouse. Unfortunatley due to family problems I missed several key sessions and am left at a loss as to where to start. Despite having the session documentation it's difficult to follow as a user who is generally unfamiliar with the workings of Oracle. We have been provided with the SQL structures for each database, and advised we should be using Designer 9i to 'forward engineer' our star schema - this, I am told, we initially populate the DW. But I am unsure as to the steps involved in doing this. I have run the SQL for the 3 databases, and I am sat with Designer 9i open - but I just need to know where to look for a tutorial or other where I can find out how to take the data from the 3 databases and insert it appropriately into one DW using 9i. Unfortunatley, the course leader is unavailable for another week but I'd like to get this done as soon as possible which is why I'm looking for help here.