datastage scd with no surrogate key state file
Posted: Tue Mar 29, 2011 10:13 am
Hi,
I have a job with an SCD stage which we are using to capture Type 1 changes.
As we are not interested in generating keys, there is no surrogate key state file and the source name in the Surrogate key tab is blank.
This job compiles fine on some PC's but on some other PC's it gives an error "Error: Property 'Surrogate key state file' for 'SCD" is required but empty.
Could any one help me to undertand why this compile error shows up on only some PC's
Thanks
I have a job with an SCD stage which we are using to capture Type 1 changes.
As we are not interested in generating keys, there is no surrogate key state file and the source name in the Surrogate key tab is blank.
This job compiles fine on some PC's but on some other PC's it gives an error "Error: Property 'Surrogate key state file' for 'SCD" is required but empty.
Could any one help me to undertand why this compile error shows up on only some PC's
Thanks