Hi,
I have some questions about combining multiple schemas within one mart
instance.
I did a biomart from multiple schemas by combining data first with a
script. However I was asked to look into a way which would not entail
copying the data (I currently made two copies of it, the combined one
and then the biomart itself). So this would require two things. First to
combine multiple schemas. Problem here is that the main tables _key
columns values are not unique over all the schemas, they are unique
within any one schema. Second thing is that the tables should be done as
views and not their own tables. This would then remove all need to copy
information.
I think that second is possible to do. Though it would essentially mean
that I have to write the SQL to create it. Martbuilder doesn't really
help in this.
First I don't know how to do. The documentation seem to indicate that
partitioned schema can combine multiple ones, but I don't see how the
_key column would be handled.
Regards,
--
Henrikki Almusa
