SCD stage - Type 1 runs, Type2 aborts
Posted: Thu Dec 16, 2010 3:00 pm
Hello Everyone,
I created an scd job for an Oracle dimension table. When the job is set up as a type 1 scd, everything runs great. When I change it to a type 2 scd, the job aborts with the following message:
scd_dw_dim,0: Fatal Error: Updatable lookup requires sorted keys.
Both of my inputs are hashed and sorted on my lookup key.
Not sure what an 'Updatable lookup' is. My lookup stage is an Oracle connector stage.
I have seen postings on DSX for this fatal message, but in regards to a range lookup. My lookup key is a single decimal column. I am using the current indicator purpose code to define my current dim record(vs. a date).
Probably a simple setting I am missing somewhere.
Any help is appreciate.
Thanks
Robert
I created an scd job for an Oracle dimension table. When the job is set up as a type 1 scd, everything runs great. When I change it to a type 2 scd, the job aborts with the following message:
scd_dw_dim,0: Fatal Error: Updatable lookup requires sorted keys.
Both of my inputs are hashed and sorted on my lookup key.
Not sure what an 'Updatable lookup' is. My lookup stage is an Oracle connector stage.
I have seen postings on DSX for this fatal message, but in regards to a range lookup. My lookup key is a single decimal column. I am using the current indicator purpose code to define my current dim record(vs. a date).
Probably a simple setting I am missing somewhere.
Any help is appreciate.
Thanks
Robert