Hi,
i have developed one job.In that i am trying to maintaine the SCD Type2 updates. my job design is like this:
DBstageLookup
|
|
V
seqFile------>SCD-------->SeqFile
|
|
V
DBstageUpdate
it is every time inserting two new records one with old values and one with new values.
The problem the record is already existed in the dimension table that is leaving as it is.
This means i have two record with same surrogate key in the dimension table why i got this error i dont know can any one have any idea.
The SCD stage is inserting 2 records insted of updating the old record and insert new record.
Please tell me how to resolve this.
Thanks inadvance,
Pravin
how it will work the SCD stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 106
- Joined: Wed Oct 04, 2006 5:21 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 106
- Joined: Wed Oct 04, 2006 5:21 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 106
- Joined: Wed Oct 04, 2006 5:21 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: