ODI - File Technology

Steps

Topology

  • Physical Architecture (The location System)
    • Duplicate the default physical data server (FILE_GENERIC)
    • Enter the host name (and eventually the connection parameters)
    • Create a physical Schema. Fill the following fields with one directory:
      • Directory (Schema)
      • Directory (Work Schema)
  • Topology Physical Schema (The directory)
  • Logical Schema (The context attached to the Physical schema)

Designer

  • Model (The description of the file)
    • Select the file technology (Scroll !)
  • Right click on the model > New Data Store
    • Configure the format in the Files tab
    • Reverse Engineer the attributes in the attributes column
  • Right click the data store > View Data

Support

ORA-00001: unique constraint

com.sunopsis.dwg.SQLWorkReposException: ORA-00001: unique constraint (DEV_ODI_REPO.AK_REV_COL) violated
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)

When reversing, verify that two headers doesn't have the same name.


Powered by ComboStrap