We use Erwin data modeler to create data dictionary , then we create a main data Model representing the logical world , It include functional, process flow and all other info regarding the business and does satisfy the business requirement.
Then we validate the main model with stake holder and data owners, once that's done , it is time to generate the final Data Dictionary including field definitions and comments.
Next phase is to create an Oracle Schema owner to hold the Physical representation of the model.
Sql*loader, Microsoft Access, Excel could be used to test some data, from Excel to Oracle we could use some third party tools to load the tables.
The logical model could be divided into many physical models, such as representation for operational data store and final Data Warehouse System.
The continuos collaboration with front end developers and team lead is essential to project success.
0 comments:
Post a Comment