Inputs Validation: BI Data Preparation
Store Targets
Columns | Validations |
|---|---|
brand | brand, channel, store_code and month combination must be unique. |
channel | 255 char limit. |
store_code | store should be present in storemap. |
month | should be in the format of yyyy-mm-dd. |
target | it is a double value. value should not be less than zero. |
Category Key Sizes
Columns | Validations |
|---|---|
category | category and sub_category combination must be unique. should be present in as key in the catsubcatmap. |
sub_category | value should be present in set of sub categories for the given category. |
sizeset_1 | 255 char limit. |
sizeset_2 | 255 char limit. |
sizeset_3 | 255 char limit. |
sizeset_4 | 255 char limit. |
Retail Calendar
Columns | Validations |
|---|---|
start_date | should be in the format of yyyy-mm-dd. Retail week start date must be " + weekStart |
end_date | should be in the format of yyyy-mm-dd. end_date should not be before start_date. Retail week end date must be " + weekEnd |
retail_week | retail_week and financial_yr combination must be unique. it is an integer. value should not be less than zero. |
financial_yr | 255 char limit. |
season | season should be present in season set of styles seasons mapping. |
Style Level Merchandise Tagging
Columns | Validations |
|---|---|
channel | channel and style_code combination must be unique. channel should be present in channelStoremap. |
style_code | style should be present in style map. |
style_tag | 255 char limit. |
Buy Quantity
Columns | Validations |
|---|---|
channel | channel, store_code and style_code combination must be unique. |
store_code | store_code should be present in storemap. |
store | 255 char limit. |
style_code | style_code should be present in sylemap. |
buy_quantity | it is an integer. value should not be less than zero. |