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!

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

Jump to Answer

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

919 views