1 person found this helpful
No, but why would you want to anyway? Are you not bringing the contents of the AIF_Open_Interface for COL06 and COL05 into the FDMEE data tables? If not you should do and reference them as lookup dimensions if you don't want their values being pushed through to the target system and if you are then you no longer have an issue referencing their values in a mapping script
Thanks for help and advice.
I just wanted to map my dimensions... i thought since i am using OIA i will have to write script according to AIF_OPEN_INTERFACE table.
In the end it did write my script according to tdataseg table and i was able to get the desired result
This is what i wrote:
WHEN UD2 = 'NITRIC ACID' AND UD8 = 'CAN' THEN 'NA for CAN'
UD2 and UD8 are columns of table tdataseg.
Thanks for help.