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
datastage scd with no surrogate key state file
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 120
- Joined: Thu Oct 28, 2004 4:24 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.
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.
"Don't let the bull between you and the fence"
Thanks
Gregg J Knight
"Never Never Never Quit"
Winston Churchill
Thanks
Gregg J Knight
"Never Never Never Quit"
Winston Churchill
datastage scd with no surrogate key state file
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?
Could it be a setting on the Client side of datastage?