surrogate key generator stage

dsscholar · Post by **dsscholar** » Wed Aug 17, 2011 7:12 am

Hi Guys,

Sequential file ---> SurrogatekeyGenerator(SKG) --- > Dataset

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.

Thanks in advance.

arvind_ds · Post by **arvind_ds** » Wed Aug 17, 2011 7:18 am

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.

dsscholar · Post by **dsscholar** » Wed Aug 17, 2011 7:46 am

Arvind,

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?

Thanks in advance.

chulett · Post by **chulett** » Wed Aug 17, 2011 7:48 am

Yes. As documented.

ray.wurlod · Post by **ray.wurlod** » Wed Aug 17, 2011 3:40 pm

The second person personal pronoun in English is spelled "you". U is one of our posters - it's a Burmese name.