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.

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

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 17 2017

Added on Jan 19 2017

#business-intelligence-applications, #fdmee, #financial-data-management, #mapping, #performance-management-applications, #script, #sql, #table

2 comments

910 views