Hi people,
I use MS Access database. For building a data warehouse, I have prepared all the primary key column (integer) following the recommendation of Kimball.
That means I have a dimension table
Country with attributes
- country id
- country name
- country lf
instead having a table with attributes
- country name
- country lf
And I also have a fact table where the “country id” is saved as foreign key.
But with "id" it makes some problems in creating categories with sub category and I can’t compare to the provided examples by cognos, because no example shows with “id” like “country id”.
Has someone already an experience with this?
ras
I use MS Access database. For building a data warehouse, I have prepared all the primary key column (integer) following the recommendation of Kimball.
That means I have a dimension table
Country with attributes
- country id
- country name
- country lf
instead having a table with attributes
- country name
- country lf
And I also have a fact table where the “country id” is saved as foreign key.
But with "id" it makes some problems in creating categories with sub category and I can’t compare to the provided examples by cognos, because no example shows with “id” like “country id”.
Has someone already an experience with this?
ras