thank you for your answer, i was supposing something like this, unfortunately i don't know where and how to specify this in my ODI configuration. Is it in the Topology? Or directly in my datasource definition? Is not long that i use ODI and i had to face alot of new situations, but this issue i don't know excatly how to solve.
Thank you in advance.
Actually it's an ODI Procedure.
PACKAGE_XML (your XML process package)
A) ODI PROCEDURE 01 (insert this step)
B) XML INTERFACES
C) ODI PROCEDURE 02 (insert this step)
Configure ODI PROCEDURES like this:
ODI PROCEDURE 01
Comand on Target: SYNCHRONIZE FROM FILE
Schema: Your Source XML Schema.
ODI PROCEDURE 02
Comand on Target: SYNCHRONIZE FROM DATABASE
Schema: Your Target XML Schema.
That is also explained on ODI Docs.
Let me know if that helps.
thank you so much, this time is working, i read about it in the documentation but from that i was not realizing that i had to use two procedures, i was supposing to do this directly in the datastore configuration in the section "command at start", "command at end" but was not working in that position and was not alerting of something strange, in the end was not influent.
I have to do some test more but the procedures change the XML if i use them so i'm positive in a success of the problem.
Thank you again.
I can confirm that is working i charged all my XML file and he understand exactly the difference now, i don't know why is not working from the Data Server configuration may be we'll need some patch. I'm using Oracle Data Integration 11g in Oracle 11g but this version is on development and is not Enterprise.
Anyway for my situation it could work good like this and is not a problem to add the steps before and after so thank you again, i read a lot of documentation but i was really not realizing that i need to put this in a procedure and use it.