ypg-data/canpipeimport — pull request #3 by ldacosta (2014-11-25 20:03:53+00:00)
Title: De-normalize Events table

In order to have good OLAP performance we need to generate 'de-normalized' Event tables. In this pull-request I get rid of the Headings table, who will have 'foreign keys' referencing the *real* Headings table

The parsing will be done as follows: let's suppose that we are parsing an Event, represented as the following XML:

33

00304200
B

00304201
A

As you can see, it has 2 headings. This will generate something 2 lines in output table, perhaps like this:

event_id | search_id | heading | heading_category
11 | 33 | 00304200 | B
11 | 33 | 00304201 | A