Question

6
Replies
2407
Views
Close popover
Raju Botu (Raju_Botu)
Aaseya IT Services PVT LTD
Principal Architect
Aaseya IT Services PVT LTD
IN
Raju_Botu Member since 2017 10 posts
Aaseya IT Services PVT LTD
Posted: January 7, 2018
Last activity: January 14, 2019
Closed
Solved

Data Flows - Partition Key

I am trying to understand how partitioning key works in data set. This is basically in the context of 7.2.1
My data set is mapped to a database table.

First question is , can the column defined as partition key have Null values ?
Is there any suggestion regarding the best number of distinct values?

Note on the form:
Define a property to distribute read operation across different nodes. To achieve best performance, make sure to use a partitioning key property with not too many and not too few distinct values.

Decision Management
Moderation Team has archived post