I don't know if I get this right about LINK_TABLE:
If we have many fact tables with columns: CUSTOMER and DATE, we can simply link them together with these two columns, which creates synthetic keys. The result will be the same as using LINK_TABLE. But since we want to avoid synthetics keys, we choose to use LINK_TABLE.
Am I right on this? Is the any tutorial regarding LINK_TABLE?
Thanks in advance!
