× Discuss on porting data from legacy systems to T24. Data mapping, Data Migration tool, Extract Statergy, Writing runbook, Cut-over, Migrate static and Financial data, Balance transfer, Technical and Functional reconciliation, etc…

How to skip record if id already exist in target

  • mpanjali
  • Topic Author
  • Offline
  • New Member
  • New Member
More
8 years 1 month ago #19080 by mpanjali
I'm doing a FT using DM Tool for account balance migration, in that case if that account has already balance, then how should I skip the records.

Please some one help me on this..It's urgent.

Please Log in or Create an account to join the conversation.

More
8 years 1 month ago #19087 by A.bishlawy
Replied by A.bishlawy on topic How to skip record if id already exist in target
what is the type of FT table ID?

Please Log in or Create an account to join the conversation.

  • mpanjali
  • Topic Author
  • Offline
  • New Member
  • New Member
More
8 years 1 month ago #19089 by mpanjali
FT Transaction Type is 'AC' and if account balance already exist ,we need to skip those account to proceed further.

Please Log in or Create an account to join the conversation.

More
8 years 1 month ago #19107 by A.bishlawy
Replied by A.bishlawy on topic How to skip record if id already exist in target
there are two ways:
1- extract existing data from FT table and compare it with the new data manually.
2- write a validation routine and attach it to the OFS.VERSION to check if the (CREDIT/DEBIT) account have any balance then through an error message.

Please Log in or Create an account to join the conversation.

More
8 years 1 month ago #19108 by A.bishlawy
Replied by A.bishlawy on topic How to skip record if id already exist in target
if you choose to go with option 2 then you have to change the OFS.SOURCE to DM.OFS.SRC.VAL or create your own to validate data before inserting.

Please Log in or Create an account to join the conversation.

Time to create page: 0.105 seconds