ODI 12c Online Training

Search This Blog

How to Concatenate Values Of 2 ODI Variables in ODI ?

June 13, 2014

Get link
Facebook
X
Pinterest
Email
Other Apps

ODI Interview Questions and Answers:

We can use SQL query to concatenate using || symbol for two variables.

select '#PROJ1.VAR1'||'#PROJ2.VAR2' from dual.

INTERVIEW QUESTIONS ANSWERS

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Get Physical Schema name using odiref in ODI

Using below method we can get Database SchemaName. select * from all_tables where owner= '<%=odiRef.getSchemaName()%>' Using below method we can get Database SchemaName for Default Physical Schema from your Databaserver. select * from all_tables where owner= '<%=odiRef.getSchemaNameDefaultPSchema()%> '

BI Publisher error : Server not initialized. Please make sure the repository is ready

BI Publisher error : Server not initialized. Please make sure the repository is ready Solution: ---------- MW_HOME\user_projects\domains\bifoundation_domain\config\bipublisher Edit xmlp-server-config.xml file add below two lines and if already exists verify both repository path. <?xml version="1.0" encoding="UTF-8" standalone="no"?><xmlpConfig xmlns="http://xmlns.oracle.com/oxp/xmlp"> <resource> <file path="${xdo.server.config.dir}/repository"/> </resource> <config> <file path="${xdo.server.config.dir}/repository"/> </config> </xmlpConfig>

ODI 12c 12.1.3 Repository Tables : Master 67 tables & Work 153 tables total 220 tables.

Master repository Tables: 67 TNAME TABTYP ------------------------------ ------ SNP_ACTION TABLE SNP_AGENT TABLE SNP_AGENT_PROP TABLE SNP_AGENT_PROP_LST TABLE SNP_ALLOC_AGENT TABLE SNP_CONNECT TABLE SNP_CONNECT_PROP ...

How to Concatenate Values Of 2 ODI Variables in ODI ?

Comments

Post a Comment