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