srinuv_11

 Profile Answers by srinuv_11 Questions by srinuv_11

• Nov 8th, 2006

 

If i want to maintain the full historical data then i will use the SCD2 here SCD2 are catagorised into three types  1) current flat 2) effective date range 3) version no. we can use any of these three.  In this we can use look up transformation, filters, update transformation and expression transformation so like that we can use depending on requirement.

calltomadhu

 Profile Answers by calltomadhu 

• Nov 8th, 2006

 

hi,

scd2 exlains you while storing the hystorical information. it will be 3 types

flags

datarange

number.

thanks

madhu

sreedhark26

 Profile Answers by sreedhark26 

• Jan 9th, 2007

 

SCD IS USING FOR MAINTAIN HISTORICAL DATA AND CURRENT DATA

EX: EMP TABLE WE CAN MAINTAIN CUSTOMER ADDRESS, AFTER ONE YEAR CUSTOMER ADDRESS IS CHANGED. SCD MAINTAINS CURRENT ADDRESS AND OLD ADDRESS ALSO.

SCD IS 3 TYPES

1. OVERWRITE THE RECORD

2.CREATE NEW DIMENSIONAL RECORD

3. CREATE CURRENT VALUE FIELD

BYE

Hanu Ch Rao

• Mar 2nd, 2007

 

I was asked this question in an interview,
Where did you implement SCD2 and what was the transformations used.
What was the complex transformations did you use.
Answers please........?

u can implement SCD2 when ur dimension having changes (thru SCD2 we maintain the full history of perticular dimension) means take cust_dim in that customer may change his city to another. on that time using surrogate key concept and version we maintain the history for that customer

suurr_key       cust_id       cname        city        version
1                          1            Hanu              Blr             1
2                          1            Hanu              Hyd           2
3                          1            Hanu             delhi           3
4                          2            ashok             blr             1

like....

in that

minimum u have to use lookup, expression, router,updatestrategy, Sequence generator Trans.

is it clear?