This a string function which allows to concatenate two different strings.
select year + '-' + week from DIM_WEEK GO
select year || week from DIM_WEEK