Data Ware Housing Question

[Silver_mani]

1.look at the stored procedures that are using this database or look at the reports that are generated from this database.

 

2. Reverse engineer the database using data modeling tools like Erwin or er studio and generate the model.

 

3.look at the application's that are using this database and find out the sourescript to the applications

 

4. You can write a sql script to pull columns with names that might be having this info, for eg columns like "records", 'Patients", Agents, providers, 

good post