cancel
Showing results for 
Search instead for 
Did you mean: 

Compound PK in IDT Business Layer

Former Member
0 Kudos

How do I create a compound PK in a Business Layer

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member4998
Active Contributor
0 Kudos

Hi

I think it’s not possible create a compound PK in a Business Layer, best practice is we can create a compound PK in a Data base level. 

Former Member
0 Kudos

Business Layer is meant to be used by business users with their familiar business terminologies . Any database complexity should always be hidden from the business user.

So that is the reason why database complexity like compound PK will not available with the business layer. This type of database feature is not available in any other BI tool semantic layer as well..