DIM Categories

SELECT
Count(category.category_guid)
FROM
Category

-----------------------------------------------------

SELECT
category.pojo_parent,
category.name_translation_key
FROM
category
WHERE
category.pojo_parent =  'TASK' OR
category.pojo_parent =  'WORK_ITEM'
ORDER BY
category.pojo_parent ASC,
category.name_translation_key ASC