Replace Field Values with Hash in Fact Table.. ¿Is it a Good Idea?

[cristian_av]

Hi

I have three fact tables, but I don't have ID for some fields, just the "Text".

As I need to compare values between the fact tables, I've reader some articles that use link tables to compare.. But all of the uses the ID of the fields. I'm trying to use Generic keys to solve the problem (I accept any other suggestion!).

So I wonder if it is a good idea to "Create" an ID for my field using a Hash Function?

Or it is something stupid and I should not do it?

Thanks

Generic keys

Multiple fact tables, same dimensions

[cristian_av]

Or is it better to use the "Text" value instead a Hash?

Or is any other way to do that?

Thanks!