CODEWITHSUNDEEP
etlbusiness-intelligencetalendstar-schema
Mohammed Amnay
Mohammed Amnay

Reputation: 73

how to put data in fact table?

i'm new in business intelligence and i design a star schema that implement a data mart to help analyst to take a decision about student grades dimensions tables : - module (module code, module name) that contains information about the module - student ( code, first_name, last_name, ....) that contains information about the model - school subject ( code, name, professor name...) - degree ( code, libelle) - specialite (code, libelle) - time(year,half year) - geographie(continent,country,city) fact table : - result ( score, module score, year score) the data source is excel file : in each file i have a set of sheet for each sheet he present a students score in "Niveau 'X' , Specialite 'Y', Year and Half-Year 'Z',Module 'U',City 'A'... my question is : how i can't put data from excel to my dimensions and fact to dimensions i suppose that is easy but i need your proposition to fact i have no idea

i'm sorry for my bad english

Upvotes: 3

Views: 3543

Answers (1)

wilson_smyth
wilson_smyth

Reputation: 1516

Most basic answer, pick an ETL tool and start moving the data. You will generally need to:

  1. Load your dimension tables first. The ID columns in these tables will link to the fact table.

  2. In your ETL package/routine to populate the fact table,

  3. select the data to be placed in the fact table from the source/staging.
  4. do a lookup on each of the dimension tables against this data to get the ID of each Dimension value.
  5. Finally do some duplicate detection to see if any of the rows are already in the fact table.
  6. insert the data.

This process will be broadly similar regardless of the ETL tool you use. There are a few tutorials that go into some detail (use google) but the basic technique is lookups to get the dimension keys.

Upvotes: 2

Related Questions