ODI 11g - Parallel, Pipelined Unload to File

Here we can see how we can leverage table functions as targets in ODI interfaces to do cool stuff! It carries on from my pipelining post. Table functions let you do all kinds of powerful transformations and are a great way for incorporating in-memory custom transformations on sets. The illustration here is using a table function to parallel unload to file, it was initially posted on the OWB blog here.

There is a viewlet right here that walks you through the creation of the interface.

There are controls at the bottom if you need to pause, or step forward/backward. 

 

Comments:

hi,
it is quite a convenient solution ; i realised there were SQL_*** KMs at the screen , could you explain any of them a little bit more or share please?

Posted by icz_cube on September 08, 2011 at 12:43 AM PDT #

Hi

Which ones? There are a few such as SQL as a source which I blogged about below;
http://blogs.oracle.com/warehousebuilder/entry/odi_11g_simple_flexible_powerful

These SQL* KMs just do the SQL generate for some functionality, for example the unpivot generates Oracle UNPIVOT SQL.

Cheers
David

Posted by David on September 08, 2011 at 03:19 AM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Learn the latest trends, use cases, product updates, and customer success examples for Oracle's data integration products-- including Oracle Data Integrator, Oracle GoldenGate and Oracle Enterprise Data Quality

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
2
3
5
6
7
8
9
10
12
13
14
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today