SCD stage state file,reading error

Puli · Post by **Puli** » Wed Feb 04, 2009 1:07 am

Hi,
while using SCD stage I had given flat file option to generate surrogate keys.flat file is created using SKG stage in another job with a single value of key in it.Error is SCD stage is not able to read the flat file given.Keys are supposed to generate using nextsurrogatekey function.
Error is

Unable to read state file /home/dsadm/dsinputfiles/Skey: Invalid argument

Thank you

ray.wurlod · Post by **ray.wurlod** » Wed Feb 04, 2009 3:27 am

How did you invoke NextSurrogateKey() function?

Puli · Post by **Puli** » Wed Feb 04, 2009 4:46 am

I used that function in the derivation part of Surrogate Key column in the Dimension Update link.

Puli · Post by **Puli** » Wed Feb 04, 2009 6:07 am

Hi All,

Also i want to know whether using the SCD stage in DS8, is it possible to capture 'delayed dimension' input records also...? Delayed dimension input record means, a record having effective date in between the effective and expiration dates of an invalidated(or expired) record, in an SCD type2 implemented dimension table.

Thanks in advance
Puli

Mike · Post by **Mike** » Wed Feb 04, 2009 7:59 am

The SCD stage does your basic type 1 and type 2 dimension processing. For your delayed dimension records (special handling), you'll have to supplement the SCD stage with some additional design of your own choosing.

Mike