Oracle Data Integrator does not have any built in functionality for subqueries in interfaces. This is one of the reasons why you will find people claiming that ODI has shortcomings when dealing with complex transformations. Shortcomings of existing workarounds In the ODI community various workarounds have been suggested to address this. The following discussion thread on OTN summarises these efforts. ...
OdiSqlUnload is a handy tool to quickly dump the content of a table into a CSV file. This is a lot quicker than first creating a file data server, interfaces etc. However, OdiSqlUnload has one major drawback. It does not allow you to load the header columns of your table(s) into the CSV. This makes the tool pretty much useless ...
We all know that we should purge the ODI log on a regular basis. if we log everything or if we run near real time batches. You can either purge the log manually from the Operator module or you can use the ODIPurgeLog tool. As per Metalink 424663.1 the following tables contain information concerning Session runtime executions
SNP_EXP_TXT (starting with ODI 10.1.3 versions):
SNP_SESS_TASK_LOG.I_TXT_TASK_MESS = SNP_EXP_TXT.I_TXT
SNP_STEP_LOG.I_TXT_STEP_MESS = SNP_EXP_TXT.I_TXT
SNP_VAR_SESS.I_TXT_VAR = SNP_EXP_TXT.I_TXT
SNP_VAR_SESS.I_TXT_DEF_T = SNP_EXP_TXT.I_TXT
SNP_SESSION.I_TXT_SESS_MESS = SNP_EXP_TXT.I_TXT
SNP_SESSION.I_TXT_SESS_PARAMS = SNP_EXP_TXT.I_TXT
When you ...
I have put together a link list of all the ODI resources I know off on the web. If you know any other relevant resources contact me and I will add it to the list below. ODI Training. Learn ODI from the experts. In my opinion the best place to get started with is the Data Warehouse Best Practices using ...
I have put together a link list of all the ODI resources I know off on the web. If you know any other relevant resources contact me and I will add it to the list below. In my opinion the best place to get started with is the Data Warehouse Best Practices using Oracle Data Integrator Enterprise Edition guide. This ...