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.
>
