Reengineer or update CFD Migration with sections/tags - Refer #4140,#4141,#4142

[abin-aot]

Title of ticket:

Description

The purpose of this task is to update the DataMigration(ETL) and DocumentMigration(script) along with new SECTIONS aka tag for CFD migrations. Need to analyze, find the tagging on AXIS and map it with the sections on FOI FLOW.

Dependencies

Are there any dependencies?

DOD

• [ ] Finalize the plan, strategy for migration - Bulk or batch without moving targets etc. or ADHOC - on demand basis - @lmullane ??
• [ ] Analyze the sections on AXIS for CFD personals request - Which table, how they related to Documents, how can we port it?
• [ ] Map the section data on AXIS to what we have on FOI FLOW? There will be gaps, for gaps we need to get mapping assistance from business - @m-prodan , @liseandtea etc..
• [ ] Create, Update the ETL development for Sections, based on the mapping adjustments
• [ ] Develop the Records migration based on the SECTIONS tagging for CFD,
• [ ] Update the ETL and Migration script as per strategy planned on DOD1 for bringing CFD personal Data AND Document - ADHOC/Bulk/Batch
• [ ] Update ETL for Identity Verified column - @aparna-aot
• [ ] Run Data validation run cycles with Business

[abin-aot]

Need to update DOD as per business, like applying OCR on documents mgiration from KINDLING to S3