June 8, 2008 at 6:13 pm
Hi,
I used Slowly changing dimension wizard in my project to get changing records to datawarehouse. But, I m getting some weird results. when I updated the records in warehouse table and run the package, all the newly updated values come under expired values and old records show up as the new values. I checked all the package and everything seems to be good. can any one help me in this?? any help would be appreciated. Thanks in advance...
June 8, 2008 at 6:47 pm
Hey,
Remember that SSIS is case and space sensitive, so even if it may appear that nothing changes, something may in fact be changing
~PD
June 8, 2008 at 7:21 pm
yeah..but my problem is...for the new records it shows as old records and old records as new records....is it like any time settings do i need to change?
June 8, 2008 at 7:26 pm
Havent worked enough with the SCD wizard to know it off by hand. But I havent heard of any kind of time settings.
Why dont you test with a small subset first, and see if you can simulate the same behaviour
June 8, 2008 at 7:29 pm
yeah...Thanks for your reply....I already did the samething...I just took 10 records and tested it...It does nt work..
June 9, 2008 at 6:37 am
Just re-check the settings in the wizard. You have your expired indicator set backwards. I know the SCD components works correctly for using a boolean to mark records expired and for using it with the dates. You just have something backwards.
You may have just been looking at it too long.
June 9, 2008 at 7:20 am
Thanks Michael...I m using the dates(start date and end date)...but Where can I find the settings?? I ve been trying to solve this past a week...
June 9, 2008 at 7:32 am
Hey...I got it...Its just I was updating the values in the dimension table instead of the source table...i went mad really...anyway thanks for both of you ...
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply