Interested to Buy Any Domain ? << Click Here >> for more details...
what is scd?
- 6 Answers
- 17957 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / pradeep
scd-slowly changing dimension
It is the capturing the slowly changing data which changes
very slowly with respect to the time. for example: the
address of a custumer may change in rare case. the address
of a custumer never changes frequently.
there are 3 types of scd. type1 - here the most recent
changed data is stored
type2- here the recent data as well as all past data
(historical data) is stored
trpe3- here partially historical data and recent data are
stored. it mean it stores most recent update and most recent
history.
As datawarehouse is a historical data, so type2 is more
usefull for it.
(welcome new answers)
| Is This Answer Correct ? | 15 Yes | 2 No |
Answer / sai suresh
SCD: Slowly changed dimention
The SCD how to Capture the change data with respect to the
time. For ex: In an organization emp sal is chaged
according to his perfomence after chaned sal we kept in
datawarehouse. (Datawarehouse maintain a Historical data )
there are 3 types of SCDs.
Type1: It will maintain curren data only. It does't
maintain historical data.
Type2: It maintain current and historical data.
Type3: It maintain current and previous data it mease
Parcial data only maintain.
So generelly datawarehouser is maintain Historical data
hence Type 2 is useful
| Is This Answer Correct ? | 15 Yes | 2 No |
The datas are kept in the data base
through the slowly changing dimension process.There are
three types in slowly changing dimensions:
type1,type2.type3.
| Is This Answer Correct ? | 12 Yes | 7 No |
Answer / rekha
SCD IS SLOWLY CHANGING DIMENSION
SLOWLY CHANGING DIMENSIONS ARE DIMNESION TABLES WITH SLOWLY
INCREASING DATA AS WELL AS UPDATES TO THE EXISTING DATA
THERE ARE THREE TYPES OF DIMENSIONS
TYPE 1
TYP2 - VERION ,FLAG ,EFFECTIVE
TYPE3
| Is This Answer Correct ? | 5 Yes | 0 No |
Any one can tell me how to explain puss-down optimization ? explain me with example plz?
What is status code in informatica?
what is shortcut in informatica? difference between shortcut,reusable object?
What is meant by active and passive transformation?
Hi 2 every one. i dont have real time experience, and please suggest me for following questions. a) we get the source data from what type of source systems? b) In banking domain project what are the FACT & DIMENTION tables please list out them? c) please write some colomn names in a table? Please reply for aboue questions?..... Thanks in advance.
how can u tune u r informatica mapppings
star and snowflake schema?
What are Rapid changing dimensions?
How many repositories can be created in informatica?
How i can Schdule the Informatica job in "Unix Corn Schduling tool" ?
How can we get multiple output values using an unconnected lookup transformation?
What is a parameter When and where do you them when does the value will be created
Teradata 
