Thanks for your reply
We already tried http://s3.amazonaws.com/Ora/KM_IKM_Pivot.zip by following the link https://community.oracle.com/thread/904535?tstart=0
But unfortunately we got the same error which is mentioned in that link
org.apache.bsf.BSFException: exception from Jython:
Traceback (innermost last):
File "<string>", line 35, in ?
java.sql.SQLException: Invalid column name
I am newbie to odi - if possible can you please guide me how to do transpose in odi by considering excel as source and oracle as target