Skip to Main Content

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
Locked due to inactivity on Feb 17 2017
Added on Jan 19 2017
2 comments
489 views