Inside SKG, i gave the file initial value as 1 and output column as surrogatekey. From the source i get 2 column registerno,names which comes from sds.txt.. In SKG, for source file name i gave an empty file name sdf.txt. I ran the job and i got the following error. I tried with last highest value option also.. I got the same error.
Error :
main_program: Fatal Error: Caught ORCHESTRATE exception in main program: APT_Archive::BadVersion: From: Loading memory archive.
Please advise. I am confused in using surrogate key generator stage.
First of all, create the flat file sequence within the scope of datastage.Then use this flat file in your other datastage jobs in surrogate key generator stage.
Could u please tell what u mean in this statement " create the flat file sequence within the scope of datastage ". U mean to say i have a create a file using only surrogatekey generator in a job, with some values in that?