First page Back Continue Last page Overview Graphics
Fact per Row ETL
Each input “row” has one Fact, plus details for each Entity
- Row can be XML entity, CSV file row, SELECT result row
Each Entity defined by a disjoint subset of columns
- Columns 1-8 define a Strategy instance
- Columns 9-10 define the Resource instance
- etc.
for r in rows:
- d1= dim1.conform( some values )
- d2= dim2.conform( some values )
- f= Fact( measure, d1, d2 )