Join primary key

[Former Member]

How do i achieve having a combination of more than 1 primary key.

It should be able to take

NAME no.

mark 12

mark 14

where name n the no are primary key?

-Paola

[Former Member · Accepted solution]

hey,

I dont think that shall work for you.

Even if there are 2 unique fields, it unfortunately doesnt take the join.

It wont allow u to enter mark 2 times saying unique key constraints.

Regards,

Tanveer.

<b>Please mark helpful answers</b>

[Former Member · Accepted solution]

Hi,

Combining 2 uniques should solve your purpose.

1. In the MDM Console select the Repository from the Left hand side grid and select the table from the Tables grid.

In the Table Detail grid, under "Unique Fields" drop down, select 2 fields from the "Available fields" and add them to the "Unique Fields" list.

Select the both the fields from the "Unique Fields" list and click the "Combine" button.

Then your unique key will be combination of "NAME" and "no", which is represented as "NAME + no".

Hope this is what you are looking for. If not please be more specific and I will try to assist you.

Thanks and Regards

Subbu

[Former Member · Accepted solution]

Hi Subbu,

Combining in Console is done. But in syndicator it should show like,

Name No

mark 12

mark 14 Right? Please correct if i am wrong.

But it is not working. Only combining will not solve the problem...

Thanks & Regards,

Ronak

[Former Member · Accepted solution]

hey subbu,ronak, tanver

any solution?

[Former Member · Accepted solution]

Hi,

Why not create one more field as a primary key(unique field) and make it auto id.

It should be able to take 2 mark with different numbers.

But why have such data in MDM repository.

Here we want to remove duplicates and not add duplicates.

MDM aint meant for transactional data to maintain different numbers for the same name.

If there are different entity with same name Mark, then you can opt for the soln as i suggested.

Regards,

Tanveer.

<b>Please mark helpful answers</b>

[Former Member · Accepted solution]

Subbu

any solution to the problem?

-Paola

[Former Member]

Hi,

In the MDM Console, select the Repository and in the right hand side grid, select the table on which you want to create the combination primary key.

In the Table Detail grid select the fields from the Unique fields drop down list.

Hope this is what you are looking for.

Thanks and Regards

Subbu

[Former Member]

hey

i know abt creating unique field but how to get the data in the format i want

-Paola