Hi Arek,
Do your main tables share the same dimensions at the moment?
That's interesting. We only see it if the main tables are related ei one
is 1:n to the other. In this case you can create a composite dataset
exactly like
you had before but one of them would have an additional key., For an
example
look at ensembl gene and transcript main tables
OK, I confess, there is a relationship. pathway:reaction is 1:n. I could
actually use the same attribute (stableIdentifier) as the key between the
two tables, since it is unique for every Reactome object. I guess I would
just have to create a column with a new name, like main_link_key or
something. One possible problem is the fact that two pathways may
share the same reaction.
So, theoretically, I could keep both tables in the same dataset. Would this
bring any advantages, apart from not needing to copy dimension tables?
E.g. would it make it easier for the user to run queries?
Cheers,
David.
