Hash Key

[ilanbaruch]

Hi All,

I have 7 tables in my model all connected with account_id field and 3 of the tables contain also user_id field (currently commented).

I miss some of the calculations because I cant relay on account_id I need the user_id.

I know can be solved by LinkTable \ KeyTable but it will increase load time.. is there another way to load also user_id field?

thank you,

Ilan

[MK_QSL]

AutoNumber(account_id & '-' & user_id) as %Key

[Anonymous]

Can you share your data model ?

[marcus_malinow]

Ilan,

the typical approaches to this are either a link table or a concatenated fact table.

[ilanbaruch]

hi,

thank you for prompt answer.

after creating the new field (%Key), should I also load the two fields otherwise how will connect to the rest of the model?

[marcus_malinow]

Actually, on reflection, does your user id have a direct relationship to account id? e.g. is there a single user id associated with an account id?

If so, and if you have an Account dimension table, you could add your user id to that table.

[ilanbaruch]

user id have a direct relationship to account id- every account  have a user id I have more users than accounts.

all starts with user and then part of them become accounts

[sujeetsingh]

Yes you load them if needed.