how it will work the SCD stage

thumati.praveen · Post by **thumati.praveen** » Thu Jan 03, 2008 7:56 am

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

ray.wurlod · Post by **ray.wurlod** » Thu Jan 03, 2008 3:21 pm

Describe - exactly - how you have set up the SCD stage - ideally with a picture of each tab.

thumati.praveen · Post by **thumati.praveen** » Sun Jan 06, 2008 10:12 am

ray.wurlod wrote:Describe - exactly - how you have set up the SCD stage - ideally with a picture of each tab. ...

Thanks for your reply.

I was done by using database constraints.

ray.wurlod · Post by **ray.wurlod** » Sun Jan 06, 2008 3:12 pm

It is not possible to use database constraints in an SCD stage therefore I ask again for you to describe exactly what you are doing in the SCD stage.

thumati.praveen · Post by **thumati.praveen** » Thu Jan 17, 2008 12:52 pm

ray.wurlod wrote:It is not possible to use database constraints in an SCD stage therefore I ask again for you to describe exactly what you are doing in the SCD stage. ...

HI ray,

before that it in the database their is no constraint thats why it was did.

Thanks,
Praveen

ray.wurlod · Post by **ray.wurlod** » Thu Jan 17, 2008 4:43 pm

You still have not described exactly what you are doing in the SCD stage which is what was requested.