There may be a faster way to do this, but you'll need to detail more information:
- How many records in the transaction_info_file?
- How many records in the Transaction_detail_file?
- What fields are the records joined on?
- What is the nature of those fields?
- How often do you need to do this?
- How long does it currently take?
- What is your target for improvement?
Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error.
Lingua non convalesco, consenesco et abolesco.
Rule 1 has a caveat! -- Who broke the cabal?