[sqlalchemy] data warehouse
Hi all, A very good day to all of you. Currently, i am working on data warehouse. I am using MS SQL. I have done quite a big of research online recentlhy. However, all i could find are defination of data warehouse and designing of data warehouse. I had both fact and dimension tables ready, but how should i create a store procedure to populate data from the different databases into my warehouse? Thanks and Regards Poy Ling --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~--~~~~--~~--~--~---
[sqlalchemy] Create tables with hierarchy relationship
Hi all, Currently i am having problem with this implementation. I have 4 tables, namely 1 parent table with 3 children tables. Primary key from the parent table is assigned to each of the children table. However, if primary key 1 is being assigned child table 1, it cannot be re-assignment to child table 2. How should i implement it? Thanks and Regards Poy Ling --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~--~~~~--~~--~--~---