Current and History tables

building semantic layer
1

I have four tables:
Current Table
Raw Table
Figs Table
History Table

All the tables have the same key related to a product. The current table holds more than one record for a given product for different dates.

The raw and figs table hold only one record related to a product.

The history table will hold more than one record for a product with different dates.

I want to create a view with a union of the Current table,raw table and figs table. I donot know How should I handle the history table… any ideas…my question may be silly…

GC_hill :us: (BOB member since 2007-08-29)

2

I think you need to give more details. What do you want your union table to show? The latest of each product? All possible permutations?

Namlemez :djibouti: (BOB member since 2005-03-14)

3

Yes i want to do a union with Current, Raw and figs tables to show the exact status of the record. I mean a product is in the current or raw or figs state. I am not sure how to handle the history table…

GC_hill :us: (BOB member since 2007-08-29)