Archives of the TeradataForum
Message Posted: Thu, 07 Feb 2008 @ 09:28:54 GMT
For setuping the DW from the current operational datasource then you have to go through the below models in implementing DW. ( Which I'm specifying is for the teradata environment)
2a.Check the tables are all in the 3NormalForm.
2b.Relationships between the entities are well defined
3.Extended Logical Model
3a.Data demographics is been colleted.
3b.Access frequency of the tables
3c.Volume of the objects
6.Move to production
After setting the logical desgin you can write scripts or some ETL tools to move the required data from the operational datasource to DW.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|