Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Multiple values for single column in Target

988115May 9 2013 — edited May 31 2013

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

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 28 2013

Added on May 9 2013

#business-intelligence-applications, #data-integrator, #mapping, #odi, #system-management-and-integration

10 comments

1,600 views