Short answer - yes. For it to function correctly it must have all the
keys present from the main table in every dimension associated with
that main table, even if all the other columns in the dimension are
null. This is because internally it is using inner joins rather than
left joins. If it used left joins, you wouldn't need to have the null
rows in the dimensions.
cheers,
Richard
On 3 Nov 2009, at 00:45, Rochak Neupane wrote:
Does biomart require that all rows from a main table have a
corresponding row in a dm table (either with real values or all NULL
values) for proper function?
For example, if we are storing PFAM domains for transcripts, where
transcripts are stored in say transcripts__main and PFAM domains in
pfam__dm, do transcripts that do NOT have any PFAM domain need to
have a row in pfam__dm with all columns set to NULL?
In our mart, we are seeing that if attributes are selected from
transcripts__main and from different dm tables, only those
transcript that have rows in ALL selected dm tables are displayed
onthe results page.
Thanks,
rochak
--
Richard Holland, BSc MBCS
Operations and Delivery Director, Eagle Genomics Ltd
T: +44 (0)1223 654481 ext 3 | E: holl...@eaglegenomics.com
http://www.eaglegenomics.com/