Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error during Mapping execution after changing the order of Datasets

hammerSep 18 2014 — edited Sep 18 2014

Hi all,

I have created a mapping using datasets.

In the mapping I use a union statement between sources. The mapping is working fine.

If I try to change the order of the datasets or delete a dataset, durning the execution i get an error, due to a malformed sintax of the union statement.

Shown below the steps:

  1) The original interface has three datasets

first_mapping_definition.PNG

  1. The first mapping execution is working. The Insert statement is created correctly:

first_mapping_execution.PNG

  1. I change the order of the datasets:

changing_datasets_order.PNG

  1. When I try to exectute the mapping with the new datasets order, I get an error. In the sql code of the execution it is clear the mistake on the sql generation (red circle)

second_mapping_execution.PNG

Where I am wrong? Any ideas or workaround?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 16 2014
Added on Sep 18 2014
#business-intelligence-applications, #data-integrator, #system-management-and-integration
6 comments
1,672 views