Does any one could tell me how can I access the target properties from inside SQL in DTL Subtransform? For example, if I use the following statement: SELECT ID INTO :target.SetIDPID  FROM firstlook.person WHERE  FirstName = 'Paul' - as said in documentation :
SELECT Name INTO :target.Name FROM MainFrame.EmployeeRecord WHERE SSN = :source.SSN AND City = :source.Home.City
I get an Error: ERROR <Ens>ErrException: <PROPERTY DOES NOT EXIST> But if I pass the value for a variable "SetIDPID" I can use it in a set action without any problem:  SELECT ID INTO :SetIDPID  FROM firstlook.person WHERE  FirstName = 'Paul'