datastage scd with no surrogate key state file

cooperjv · Post by **cooperjv** » 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

greggknight · Post by **greggknight** » Tue Mar 29, 2011 1:02 pm

I have the same issues with the OLE DB for sql server.
It requires values in all the properties, before sql after sql so on.

To get around this I just put in a char(32) space. It then compiles
I have not contacted IBM on this because I am on 8.5 now and the object is depreciated. We are migrating them to the enterprise.

So the work around works for me in the mean time.

cooperjv · Post by **cooperjv** » Tue Mar 29, 2011 1:55 pm

Greg, Thanks for the suggestion. It works when you enter a space. Still the question remains why does it compile without the space on one PC and requires a space on another PC.

Could it be a setting on the Client side of datastage?