We have requirement to update main table (>30millions) based on business rules & lookup files. There are 46 lookup files with different schema & business rule. The priority to update is set for each lookup file & it need to done accordingly.
File Priority
File Name
1
AA.txt
3
BB.txt
2
XX.txt
4
ZZ.txt
In this case the update will happen in order: AA,XX,BB,ZZ
The solution which we can think is:
Main Table -->(Lookup AA.txt)-->
tMap1--->(Lookup XX.txt)-->
tMap2--->(Lookup BB.txt)-->
tMap3--->(Lookup ZZ.txt)-->
tMap4--->so on...
Is this approach feasible? Whether it is achievable with one tMap?
Please suggest optimum development approach for this scenario.
Thanks