ODI Interview Questions and Answers:
How to Get Current Repository in using Substitution Method?
In master repository we can find all work repository names in SNP_REM_REP table. Using getSession method we can get REP_ID and using below query we can get repository name
select REP_NAME
from <%=odiRef.getObjectName("L", "SNP_REM_REP", "D")%>
where REP_ID = to_number(substr(to_char(<%=odiRef.getSession("SESS_NO")%>), length(to_char(<%=odiRef.getSession("SESS_NO")%>))-2, 3))
How to Get Current Repository in using Substitution Method?
In master repository we can find all work repository names in SNP_REM_REP table. Using getSession method we can get REP_ID and using below query we can get repository name
select REP_NAME
from <%=odiRef.getObjectName("L", "SNP_REM_REP", "D")%>
where REP_ID = to_number(substr(to_char(<%=odiRef.getSession("SESS_NO")%>), length(to_char(<%=odiRef.getSession("SESS_NO")%>))-2, 3))
No comments:
Post a Comment