Skip to Main Content

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

FDMEE mapping sql script table?

JanGLiJan 19 2017 — edited Jan 20 2017

Hi,

According to fdmee mapping example by oracle it seems that we can use only tdataseg table.

pastedImage_2.png

Can we use other tables in sql scripts while creating like mapping? if yes can you guys suggest how?

This is my script, i created this script considering aif_open_interface table

CASE

WHEN COL06 = 'NITRIC ACID' AND COL05 = 'CAN' THEN 'NA for CAN'

ELSE 'IGNORE'

END

Kindly advice how to correct it?

Regards

This post has been answered by SH_INT on Jan 19 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details