sábado, 18 de agosto de 2012 17:39
I have a database including these tables
student,subjects,marks,etc in mark table i have the columns which will be predict. i want to create data warehouse in order to create mining models for get predictions.
I want to know what table is prefer to as a fact table and what are the dim tables ?
Todas las respuestas
sábado, 18 de agosto de 2012 18:22
you do not need a "data warehouse" to create data mining models.
- Marcado como respuesta it375420 miércoles, 29 de agosto de 2012 13:28
domingo, 19 de agosto de 2012 5:16thanks for the reply :) but the thing is this is my research project so my examiner wants to do this using warehouse.
domingo, 19 de agosto de 2012 5:35
ok - sorry about assuming.
I do not want to give out a straight answer because it's your project. But In simplest of terms:
Fact table contains numbers (that you want to sum/average/count/...)
Dimension Table contains Fields that you want to group them by.
So if you want to group "average(marks)" by subjects.
your fact = marks
your dimension = subject
I hope it's a decent starting point for you.
miércoles, 29 de agosto de 2012 13:29I will look in to it,thanks for your support !!! :)