We are creating an Relational Universe based on SQL queries given by the user, need to assign SQL query for an object in IDT- Data foundation layer
Below is the code...
E.EFFDT=(Select Max(E_ED.EFFDT) From Table
Where E.SETID = E_ED.SETID
AND E.ACCOUNT = E_ED_ACCOUNT
AND E_ED.EFFDT <=SYSDATE)
Can any one help me on this how to assign the above SQL query for an Object(EFFDT)