Datawarehouse Architect

Below are the steps to be followed to create master and work repository in ODI 11g and ODI 12c. Create user ODIMR and give connect and resource privilege  Open ODI and go to Master Repository creation wizard - Give all the DB credentials as mentioned below Create Master Repository Creation Wizard - Authenticate with SPERVISOR user. Click Finish You master repository creation was successful and it will show as below. to to New Gallery and click on Create a new ODI repository login Give the Database details as follows and test the connection  Go to topology and right click the work repository and create new work repository  click on test connections Give Yes and proceed further Give your default password Give Yes Create Login name Login to ODI ...

I am trying to create master repository in ODI and I encountered below error ception: java.sql.SQLSyntaxErrorException: ORA-01950: no privileges on tablespace 'USERS' When I did little research I understood that I have not given unlimited quota access to my schema and I have given below access.

While importing in Oracle data integrator (ODI) I have faced Java heap space error and below is the same error. java.lang.OutOfMemoryError: Java heap space at oracle.jdbc.driver.T4C8Oall.initBindsDefinition(T4C8Oall.java:1524) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:234) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:55) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1006) at oracle.jdbc.driver.OraclePreparedStatement.executeForRowsWithTimeout(OraclePreparedStatement.java:15398) at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:15546) at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:264) at oracle.odi.runtime.agent.execution.sql.BatchSQLCommand.executeBatch(BatchSQLCommand.java:110) at oracle.odi.runtime.agent.execution.sql.SQLCommand.end(S...

Hi Mates, Today I have completed Oracle data Integrator certification exam (1z0-482)... Exam was little bit complicated when comparing to my previous BI and OCP certifications. I had very good experience after writing 1z0-482 - Oracle Data Integrator (ODI) certification. I'm the first guy to have OBIEE, OBIA OCP certification along with ODI certification in my organization. I have verified multiple ODI article , books, blog related to ODI. Finally purchased 1z0-482 (Oracle data integrator) certification dumps in PDF format online also. I have cleared my 1z0-482 exam with 94%. Thanks for all your support. Regards Kashif.M Email - coogle7222@gmail.com Ph - +91 9994883085

Step by Step Installation method for Oracle Data Integrator (ODI) Oracle Data Integrator is going boom in coming days, since OBIA 11.7.1 has been implemented with Oracle Data integrator as its ELT process instead of Informatica. Find below screen shot, just follow this to install oracle data integrator (ODI)