On 18/06/09 9:32 AM, "Arek Kasprzyk" <[email protected]> wrote:
>
>
>
>
> On 18/06/09 9:12 AM, "Syed Haider" <[email protected]> wrote:
>
>> Hi Liisa,
>>
>> you can definitely have as many _key columns in one table as you want to.
>>
>> Syed
>>
>
> Hi Lisa,
> There are certain rules to these columns. You would typically have one _key
> column in the main and additional _key column for each submain. Dimensions
> should have one _key column, identifying which main table they belong to.
> Can you give us an idea why do you need more 'key' columns so maybe we can
> explain better?
If your primary key is a combination of multiple columns, you will have
multitple _key columns if you use martbuilder to do the transformation.
>
> A.
>
>
>>
>> Liisa Koski wrote:
>>>
>>> I think I have a related question...can you have two different _key
>>> columns in one table?
>>>
>>> Cheers,
>>> Liisa
>>>
>>>
>>>
>>>
>>> *Syed Haider <[email protected]>*
>>> Sent by: [email protected]
>>>
>>> 2009-06-18 08:30
>>>
>>>
>>> To
>>> [email protected]
>>> cc
>>> "[email protected]" <[email protected]>
>>> Subject
>>> Re: [mart-dev] link dataset on _key colomn
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> Hi Berenice,
>>>
>>>
>>> sure, its possible. you need to declare importable and exportable for
>>> the said fields.
>>>
>>>
>>> Cheers
>>> Syed
>>>
>>>
>>> [email protected] wrote:
>>>>
>>>>
>>>> Hi,
>>>>
>>>> I would like to known if it's possible to link a dataset via the _key
>>>> field.
>>>> For exemple, I have two dataset A and B. A contains a field Bid that I
>>>> would like to link to the dataset B on the field id_key.
>>>>
>>>> Thanks,
>>>> Bérénice
>>>
>
Yong Liang
Database/Application Programmer
Ontario Institute for Cancer Research
MaRS Centre, South Tower
101 College Street, Suite 800
Toronto, Ontario, Canada M5G 0A3
Tel: 647-260-7951
Toll-free: 1-866-678-6427
www.oicr.on.ca
This message and any attachments may contain confidential and/or privileged
information for the sole use of the intended recipient. Any review or
distribution by anyone other than the person for whom it was originally
intended is strictly prohibited. If you have received this message in error,
please contact the sender and delete all copies. Opinions, conclusions or
other information contained in this message may not be that of the
organization.
