ODI 12c Online Training

Search This Blog

ODI12c CDC -Change data capture step by step process

July 06, 2014

Get link
Facebook
X
Pinterest
Email
Other Apps

ODI12c CDC -Change data capture step by step process

Step1:

Step2:
Enabling at model level as Simple and JKM

Enable at Table level Add to CDC & Start Journal

Start journal

Click on ok

CDC

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 ...

ODI12c CDC -Change data capture step by step process

Comments

Post a Comment