I have a survey with 10 questions. 50 Persons have completed the survey, so I have table with 500rows in my table XXX.
Issue: I have one column in table XXX that is the question. So 500 columns where un question appears 50 times.
Question: In warehouse, as questions is not friendly to use it coding, I would like to know how to tag the questions. So I add a new column where values are from 1 to 10, one for each question.
Any advice in how to do this in teradata?