what is scd?
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 |
Work flow failed when it is set to Bulk mode but it was successful when set to normal mode y??(All the connections are fine and exactly correct)?
Are there any types of Dynamic Caches in informatica
Hi, I am unable to connect ports from two Active trasformations to another active transformation ? Why is it so? Why it is designed like that? Some rules has been designed like this that is We can't connect passive and another passive to active.Can any one please letme know all these rules. Ex:- I am trying to connect filter1 and filter2 to another filter. Please answer me Advance Thanks
While importing the relational source definition from the database, what are the metadata of source that will be imported?
how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!
To import the flat file definition into the designer where should the flat file be placed?
What are Dimensions and various types of Dimensions?
How is union transformation utilized?
in flatfile target how can u create header and footer plese give me the comands how will u write in session properties
How to enter same record twice in the target table,explain?
How to use Normalizer transformation?
What is DR strategy for Informatica project?