Copy Surrogate key flat file from old to new environm
Posted: Wed Apr 18, 2018 10:04 am
Hello everyone,
i am in the process of migrating parallel jobs from 8.5 to 11.7. some of my jobs use surrogate key's and we are using Surrogate key falte files in transformer stage. i copied all the *.key files from old to new environment but when i run the jobs in v11.7 , it is unable to read the surrogate key files and throwing error "APT_CombinedOperatorController(1),1: Internal Error: (start <= end): surrkey/keystate.C: 107 "
we want to maintain same seq number for our loads, so we need the old files to generate surrogate keys.
We tar surrogate key files from old environment and untar in new environment. When i try to open the file it is in binary format so its unreadable.
Any help is appreciated.
i am in the process of migrating parallel jobs from 8.5 to 11.7. some of my jobs use surrogate key's and we are using Surrogate key falte files in transformer stage. i copied all the *.key files from old to new environment but when i run the jobs in v11.7 , it is unable to read the surrogate key files and throwing error "APT_CombinedOperatorController(1),1: Internal Error: (start <= end): surrkey/keystate.C: 107 "
we want to maintain same seq number for our loads, so we need the old files to generate surrogate keys.
We tar surrogate key files from old environment and untar in new environment. When i try to open the file it is in binary format so its unreadable.
Any help is appreciated.