link table concept

[paulyeo11]

Hi All, as HIC said before we start to write QV script , 1st need to come out the data table .

I like to know the concept of link table. in order for 3 of my below table to link to each other. i.e.  sales table supplier table and GL table. total 3 table i need to link.

Do it mean that i need to create link table , and it must have 3 field like below :-

link_supply_key

link_sales_key

link_GL_key

And sales table i need to have :-

link_sales_key

as for supplier table i need to have :-

link_supply_ley

as for GL table i need to have :-

link_GL_key

Hope some one can confirm with me.

Paul

[Anonymous · Accepted solution]

Sounds like you understand the concept. The link table will have a set of keys that each link to another table. These tables will be transaction or dimension tables.

I load in each transaction table, autonumbering the transaction table key, as well as the keys to the dimensions, renaming them with a prefix of the transaction table name.

I then concatenate all the records from the transaction table into the link table, leaving the transaction table key with the same name but renaming all the dimension keys by removing the transactions table prefixes (so that there is only one link between the transaction table and the link table).

The dimensions are then linked on later by having the same dimension key names.

Jonathan

[paulyeo11]

thank you vey much for both reply. i still trying to figure out.