Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Thanks!
If these other field only have the same name, but different meaning, rename these fields using AS in your load script.
There are two solutions:
1)Linked Table with all common fields that link all table with a key (common fields concatenated)
2) concatenate all fact table with Common fields, and add a common field for every table with a label for identify the table in presentation layer trough set analysis
regards