ODI 12c UNPIVOT Component Not Allowing Multiple Columns
(Doc ID 2010136.1)
Last updated on JANUARY 06, 2020
Applies to:Oracle Data Integrator - Version 188.8.131.52.1 and later
Information in this document applies to any platform.
The UNPIVOT component of ODI 12c is not allowing to select multiple columns.
Having 200 columns on some tables and having a 100 pairs of data (code+value) which are needed to be un-pivot in a way where the result is to pass those 200 columns to 2 in 100 rows.
Example Query (the important thing is the UNPIVOT, in reality this query does not have any real sense):
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