Where to Install Standalone Agent in ODI

ODI is a true ELT tool: no middle-tier server is required. Everything runs in the db, all operations can be run by a lightweight agent. Therefore without a dedicated server, where to install the agent? Source systems are not ideal – they could be dispersed widely… so installing the agent on the target systems appears more appropriate.…

CDC with MD5 function in Informatica

What is the MD5 Function? MD5 (Message Digest Function) is a hash function which is used to evaluate data integrity.  It is based upon Message-Digest Algorithm 5 (MD5) which calculates the checksum of the input value, it is a one-way cryptographic hash function with a 128-bit hash value. MD5 returns a 32 character string of hexadecimal…

Informatica Web Services

Informatica has its metadata & data integration functions exposed as webservices to allow accessibility by any third party application.  This means that workflows can be run from outside Informatica.  Apps can be written in any language to communicate with the Power Center integration services. What is SOAP and WSDL ?  Simple Object Access Protocol is the communication protocol that defines…

Estimate Index Size in OraDB

We can use explain plan for Index create to estimate the size of an Index.   SQL> EXPLAIN PLAN FOR CREATE INDEX DB_OBJECT_IDX ON DB_OBJECT(COL_NAME); SQL> SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY); … PLAN_TABLE_OUTPUT … estimated index size: 159M bytes But this does not give good enough estimates when majority values in the column are NULL.

Auto start pluggable databases in oracle 12c

Oracle Database 12c does not have mechanism to automatically open pluggable databases i.e. container database starts, but all pluggable database stay in the mount state, not open. To run automatically, we can use a trigger. CREATE or REPLACE trigger OPEN_PDS After Startup on Database BEGIN execute Immediate ‘alter pluggable All Open’; END; to test      …

Processing RSS in ODI

We can process RSS using ODI XML technology which has a driver whose file specification includes support for filesystem, URL and ftp. Use a url like below to define an XML dataserver. jdbc:snps:xml?f=http://feeds.bbci.co.uk/news/rss.xml&s=BBC&dtd=d:/bbcrss.dtd When you use the selective reverse engineer you can see the available datastores in the model generated.; To access the URL from within ODI…