My Oracle Support Banner

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

Last updated on NOVEMBER 18, 2019

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


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.