This is a scenario where a Insert event in SQL server causes the table data to be published. The Oracle resource forms the target for the document published by the SQL server adpater.
SQL server=> Oracle
The operation also involves filling in some of the fields to be cross reference from the oracle target for some of the document values.
I am able to perform this operation technically. But i am not sure of how a canonical structure shoud be.
What should be the criterias to be taken in to before building the canonical Document.
My assumption for the Following Scenario
SQL server Table has the following columns from “Table_A”.
- Employee ID
and this data is to be transformed to a table “Table_B” in oracle with the following Columns :
The columns EmployeeName and Age will be evaluated by cross -referencing another table in Oracle “Table_C” where the employee details are stored.
My assumption is the document shoud represent the target system.
By having the following in the document:
How is the canonical model to be implemented for this type of scenario
I am not able to get into terms with this.
Could somebody throw some light on this.
Thanks in Advance,