Hi Yong,
> * Do optimiser columns need to have a certain naming scheme? > An optimiser column has the pattern like content_bool > > * If you put optimiser columns not in the main table but a separate table > what > > should the table name be? > The table name should look like dataset__content_bool__dm, which includes > the key column in the main table, and content_bool columns for each > dimension table. > Sorry some additional questions... could we try with a real example? I'm particularly interest in split optimiser count columns. If you were to just put them in the main table how would they look? Let's say I have a "model" dimension table with the following columns, "provider" and "organism", and I wanted to make split optimiser count columns for them. Would their column names in the main table be provider_count and organism_count? How does BioMart then know to use them properly and that they are not regular (non-split) count columns of the "model" dimension? > * What are index optimiser columns? What do they produce when checked in > > MartBuilder so that I can add them manually? > The optimiser columns are for sub main table, and automatically checked in > MartBuilder. It will automatically generate a sub main content_bool column > in main table. > I cannot use MartBuilder because I don't have a source schema, so what does the Index Optimiser Columns produce SQL-wise? Does it produce nothing if you only have a main table (and of course dimensions) but no subclass tables? thanks, Leandro On Wed, Jun 9, 2010 at 4:32 PM, Yong Liang <[email protected]> wrote: > > > > On 09/06/10 9:11 AM, "Leandro Hermida" <[email protected]> wrote: > > > Hi BioMart team, > > > > I haven't used MartBuilder for a mart I've built because there isn't a > source > > schema and I was wondering if you could help me with how I should add > > optimiser columns manually to my mart? Just a few questions: > A simple table has the naming schema like dataset__content__type > > > * Do optimiser columns need to have a certain naming scheme? > An optimiser column has the pattern like content_bool > > * If you put optimiser columns not in the main table but a separate table > what > > should the table name be? > The table name should look like dataset__content_bool__dm, which includes > the key column in the main table, and content_bool columns for each > dimension table. > > * What are index optimiser columns? What do they produce when checked in > > MartBuilder so that I can add them manually? > The optimiser columns are for sub main table, and automatically checked in > MartBuilder. It will automatically generate a sub main content_bool column > in main table. > > > thank you, > > Leandro > > > Hope that help. Let me know if you have any questions. > > > > >
