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 to [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:

Product1     Jan      Val1
Product1     Feb      Val2
Product1     Mar      Val3


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