How To Get Current Login User Name in ODI

ODI Interview Questions and Answers:

We can use below query to get current login user name.
All users sessions we can find in SNP_SESSION table and based on GetSession method we can find the current login user session and passing in where clause condition.

select USER_NAME from SNP_SESSION where SESS_NO = <%=odiRef.getSession("SESS_NO"

)%>