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