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
SCD stage state file,reading error
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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
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