Data update from source to another source

[Former Member]

Hi,

Need to get some advises which component should be use regarding the following scenario:

Scenario 1: New transaction added

Source A have 10 transactions and Source B have only 9 transactions. I need to copy and update the transaction #10 from Source A to Source B without copy other transaction.

Scenario 2: existing transactions have been updated

Source A have 10 transactions and someone make changes in transaction #3 let said change the quantity from 10 to 12. In Source B transaction #3, the quantity is still 10 and I need to copy only the updated transaction #3 over from Source A to Source B.

Scenario 3: Transaction deletion

Someone delete one of the transaction from Source A from 10 to 9, while in Source B, the transactions are still remain 10. If I need to update Source B regarding one of the transaction has been deleted, how can I get that work?

Please kindly advise.

Thank you.

[former_member187605 · Accepted solution]

Start here: , and follow the links to the wiki pages from that document.

[Former Member · Accepted solution]

Hi,

May I know what is the difference between table comparison and map operation. both seems serve the same purpose. Please advise.

Thank you.

[former_member198401 · Accepted solution]

Table Comparison will compare the source table with target table based on Primary key column and will generate opcodes insert, update and delete.

Map operation is used to perform below operation on target table.

          Insert/ Update/ Delete

We can allow only inserts or updates as per our requirement..

Regards

Arun Sasi

[former_member198401]

Table comparison transform will be sufficient for your requirement.

Source A(Source Table)> Query Transform> Table Comparison Transform> Source B(Target Table).

Scenario 1: Insert

Scenario 2: Update

Scenario 3: Delete

Table Comparison will compare Source A and Source B(Target) and depending upon the DML transaction(Insert, Update, Delete) it will create opcodes I, U and D respectively and accordingly update the Target Table.

Regards

Arun Sasi