How To Create a Pivot Table In Reverse Engineering Using ODI (Doc ID 1140650.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Data Integrator - Version 10.1.3.5.0 to 11.1.1.9.99 [Release 10gR3 to 11gR1]
Information in this document applies to any platform.
PRE.cjk { font-family: "NSimSun", monospace } P { margin-bottom: 0.08in } -->

How would one pivot a table using Oracle Data Integrator (ODI)?

For example, how to pivot the following four columns MY_TABLE table:

PRODUCT      JAN     FEB       MAR
------------+--------+--------+-------+
Product1     Val1     Val2     Val3

to the equivalent three columns MY_PIVOT_TABLE table:

PRODUCT      MONTH    COLVALUE
------------+--------+----------------+
Product1     Jan      Val1
Product1     Feb      Val2
Product1     Mar      Val3
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms