SCD Design
Posted: Wed Apr 30, 2008 11:10 am
I am trying to get the following design working and please need some help
I have one main input stream and one reference (DIM table). If no records exist in the main stream and 1 exists in the dimension, I want to set the dimensional record expiry date. I selected one business key and many type 2 keys as the lookup. None get processed.
Can the SCD stage handle this and if so, could someone point me in the right direction. Again, the documentation is very poor on this.[/img]
I have one main input stream and one reference (DIM table). If no records exist in the main stream and 1 exists in the dimension, I want to set the dimensional record expiry date. I selected one business key and many type 2 keys as the lookup. None get processed.
Can the SCD stage handle this and if so, could someone point me in the right direction. Again, the documentation is very poor on this.[/img]