Columns to Rows Issue in Dimension

This is my DimCustomer:

SKey	NKey	FOOD1	FOOD2	COLOR1	COLOR2
1	111	CHI	AM	RED	BLUE
2	222	AM	ITA	ORANGE	YELLOW

We want to be able to tell how many customers at any point in time have RED as favorite color, or ITA as favorite food.
My guess is that this probably needs to be a Factless-Fact table:

SKey	FKey	K	V
1	1	FOOD	CHI
2	1	FOOD	AM
3	1	COLOR	RED
4	1	COLOR	BLUE
5	2	FOOD	AM
6	2	FOOD	ITA
7	2	COLOR	ORANGE
8	2	COLOR	YELLOW

Is that the best way to approach this problem?

Or a bridge table. You could cram all the colors into one column, but I always cringe when I see that.

I'm sorry but I am quite new to BI, so what would the bridge look like in this case?

Thank you for your time.

why don´t you launch a simple query against the dimension and filtering by the criteria you want?
Unless you have any other type of specific reporting requirements, I wouldn´t do anything but a quick query.

I just found this reply from ngallemo:
http://forum.kimballgroup.com/t689-bridge-table-for-patient-diagnosis#2893

I assume you are referring to the same thing?

Yes. Although I am still not sure what you are trying to build. A better approach is to tell us what you want and then we can help with the how.

In the first table of your initial post, why do you have two columns for food and color? what's the difference between FOOD1 and FOOD2?

Hang,

My original DimCustomer looks like that with two FOOD and two COLOR fields because the source DB stored it like that.
That's why I am asking what is the best practice when storing such data in the data warehouse DB.

Thank you

What you have is a many-to-many relationship between dimensions, i.e. customer to color, and customer to food. You could create a factless fact table, or combine the color and food dimensions into a junk dimension and make it an outrigger off the customer employee.