I have a Worker table that has a Nationality code column (10 codes, one for domestic and 9 for international), how to creat a dimension that gives me only wither the code is domestic or international)

  • Interview Candidate
  • 1
  • 2164

Showing Answers 1 - 1 of 1 Answers

Siva Kumar Rachaputi

  • Sep 2nd, 2006
 

Hi,

I think you can create a dimension object with decode statement.

decode(code,code_val1,'National',code_val2,'International',code_val3,'International'....)

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions