This discussion is archived
10 Replies Latest reply: May 31, 2013 7:51 AM by RAM_STUDENT RSS

Multiple values for single column in Target

988115 Newbie
Currently Being Moderated
Hi all,

I have 4 columns in target of my interface like stu_id, name, sub and sub_complexity. I have stu_id, name and sub values form source but I need to hard 3 values for sub_complexity for each subject.

For example if the values are stu_id =1 , name= david, sub=eng then I need to have sub_complexity as eng_tough , eng_moderate and eng_easy .

exactly like this

stu_id =1 , name= david, sub=eng sub_complexity=eng_tough
stu_id =1 , name= david, sub=eng sub_complexity=eng_moderate
stu_id =1 , name= david, sub=eng sub_complexity=eng_easy.

Can any one help me how to code this in ODI target. The values can be hardcoded.

Thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points