Hi Ayton:

We're looking into your question and will get back to you soon.

Regards,
Christina

________________________________
From: [email protected] [mailto:[email protected]] On Behalf Of 
Ayton Meintjes
Sent: Wednesday, August 26, 2009 11:37 AM
To: [email protected]
Subject: [mart-dev] Dynamic attribute set

I have the following three tables in a custom database:

Population [id, name]
Marker [id, rsid, allele_A, allele_B]
AlleleFrequency [id, fk_population_id, fk_marker_id, freq]

How would I go about creating a mart that the user can query for markers and 
get results in the form:

rsid  | CEU_freq | JPT_freq | YRI_freq
rs12 |    0.05     |    0.55     |  0.75
rs34 |    0.95     |    0.65     |  0.05

In other words, the number of attributes available depends on how many unique 
populations there are? The automate push action and partitioning seem to 
suggest this sort of structure might be possible.

Thanks in advance

Reply via email to