Here is a use Case:
There is one table "Table_1" with you, in another software release few columns Col1,Col2,Col3 got added to the table. Business have a third party system that will provide you with the value for these newly added columns along with the row identifier or the record identifier like the primary key or some key value for the record.So essentially the data that you are going to get for updating the Table_1 data is (PK,Col1,Col2,Col3) where PK is the record identifier like the empid in case of an Employee table. So we have to load the other columns now in one initial load.
Solution:
Alter the Target_1 table and add the extra columns to it. Col1,Col2,Col3.
The PK column would have been already there.
Create a Model for the source data : (PK,col1,col2,col3)
Reverse Engg Table_1, so that new columns are displayed in the datastore.
Create an Interface, drag the source data store into the source data store panel in ODI and the target data store in the Target Data panel.
Start the mapping, Map in Table_1 only PK,Col1,Col2,Col3 from the source datastore.
Select IKM Oracle Incremental Update as the Integration knowledge module.
(The places to select the KM is different in 11g and 12c.) I hope you know those places.
Save the interface and run, that's it, on completing the interface run, check that the new columns that were added to the Table_1 are updated with the values provided by the 3rd party.
There is one table "Table_1" with you, in another software release few columns Col1,Col2,Col3 got added to the table. Business have a third party system that will provide you with the value for these newly added columns along with the row identifier or the record identifier like the primary key or some key value for the record.So essentially the data that you are going to get for updating the Table_1 data is (PK,Col1,Col2,Col3) where PK is the record identifier like the empid in case of an Employee table. So we have to load the other columns now in one initial load.
Solution:
Alter the Target_1 table and add the extra columns to it. Col1,Col2,Col3.
The PK column would have been already there.
Create a Model for the source data : (PK,col1,col2,col3)
Reverse Engg Table_1, so that new columns are displayed in the datastore.
Create an Interface, drag the source data store into the source data store panel in ODI and the target data store in the Target Data panel.
Start the mapping, Map in Table_1 only PK,Col1,Col2,Col3 from the source datastore.
Select IKM Oracle Incremental Update as the Integration knowledge module.
(The places to select the KM is different in 11g and 12c.) I hope you know those places.
Save the interface and run, that's it, on completing the interface run, check that the new columns that were added to the Table_1 are updated with the values provided by the 3rd party.
No comments:
Post a Comment