Hi All,
I have an existing mapping where I will be loading flatfile data to Hyperion Essbase 11.
This is achieved in 2 interfaces.
1. 1 Flat file, 1 Oracle table to Oracle(staging)
2. Oracle(Staging) to Hyperion Essbase
I am currently working on interface 1 which has 2 sources: a flat file and a oracle table with a join condition and a oracle target . The change is addition of 2 new columns. I have added 2 new columns to the flat file. I have added these 2 columns to the target oracle table also. I did not changed any of the KMS which are :
1. Oracle File to SQL
2. LKM SQL to Oracle
3. IKM SQL Control Append – Mindstream – DataQuality – Testing
Staging Area Diff From Target is not checked.
Data is not getting populated to target oracle table. I get the following error.
Error: ODI-1228: Task TXT_ORA Load 7B data_V2 (Integration) fails on the target ORACLE connection ORA_HYPTEST.
Caused By: java.sql.SQLSyntaxErrorException: ORA-00936: missing expression
I tested the connection in the physical schema and is fine. I am able to see the table structure also in the mapping tab with which I think I am connected to target.
Kindly advice.
Thanks